Find Jobs
Hire Freelancers

Write an SQL query

$10-30 USD

已完成
已发布超过 5 年前

$10-30 USD

货到付款
Hi, I just want one query. I want it to show the customer ID with the first name and last name, just like the table 'most tickets bought', instead I want it to have the total money spent by each customer including money spent on tickets as well as money spent on orders. For the orders, I have a table called orders with the order id and customer id, another called product orders with the order id, product id and ordered quantity and a table called products with product id and price. You will have to obtain the total spent by adding the total amount spent on tickets and the total money spent in orders, obtained by product price * ordered quantity for each customer. Please try to use simple sql language as I am a basic user and will not be able to understand the advanced functions in SQL.
项目 ID: 18200388

关于此项目

3提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
I m a database administrator with 8 years of experience in this industry. I read your project details and attached files and I understood your needs ,I can do what you want in the deadline just contact me and we can discuss more about the project.
$10 USD 在10天之内
4.9 (37条评论)
5.7
5.7
3威客以平均价$15 USD来参与此工作竞价
用户头像
hi, i would like to get the total money spent on tickets as well as money spent on orders from the tables product and orders.
$20 USD 在0天之内
4.9 (136条评论)
6.3
6.3

关于客户

UNITED STATES的国旗
Brookline, United States
5.0
1
付款方式已验证
会员自11月 20, 2018起

客户认证

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