Find Jobs
Hire Freelancers

Create some basic SQL queries

$10-30 USD

进行中
已发布大约 10 年前

$10-30 USD

货到付款
Hello, I have a few simple SQL tasks that I need done. I am translating data from my excel sheets and basically need to do all the functions in SQL, here is my list: 1. Count all Blues, Greens, Purple and Pink from a column in a SQL table for Type1, Type2, Type3 and Type4 and put them into a new table that will look like the following. Type1 Type2 Type3 Type4 Blue 24 53 34 34 Purple 34 0 1 89 Pink 87 98 678 8 Green 98 90 78 6 So to summarize in one table in one column the query needs to count the Amount of Blues for Type1 for ex. And so on… and then create this table. 2. A query that will say basically if one table an ID number like TP3435 matches another table then it will put a definition and add it to the first table. To summarize: if Table one had various ID’s and one was TP3435 and Table two had a list of ID’s and one was TP3435 and it had a definition, then in Table one you would need to copy that definition from Table two into Table 1. 3. A query that will count all of the word Test34 for example in one column and then prefill another table. Table1 column 1 had 45 Blues, 34 Purples, and 34 Pinks in test Table1 column 2 had 32 Blues, 34 purples, 23 pinks done table1 column 4 had 56 Blues, 36 Purples, 90 pinks total The table needs to be filled with the following information. Totals Total Colors Done In test Blue Purple Pink Totals 4. On a button click I want the values from the columns above to fill a row in a table. For ex. ID Date Totals Blue Purple Pink 4 3/4/2014 34 234 34 234 <- these would be the values from the above table and would be activated on button click to fill once per day. I attached the northwind database as a sample datasource.
项目 ID: 5532660

关于此项目

2提案
远程项目
活跃10 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
2威客以平均价$40 USD来参与此工作竞价
用户头像
A proposal has not yet been provided
$35 USD 在1天之内
4.9 (8条评论)
3.2
3.2
用户头像
Hi, I am an experienced programmer and developer, Writing SQL queries forms an important part of what I do. Regarding your project, firstly the queries would be complex and complicated and require some amount of work. Secondly, you have not attached the northewind database as a sample datasource. Looking forward to working with you...
$45 USD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Crestview, United States
5.0
108
付款方式已验证
会员自2月 22, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。