Find Jobs
Hire Freelancers

Write an SQL query

$10-30 USD

Completed
Posted over 5 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 18200388

About the project

3 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 10 days
4.9 (37 reviews)
5.7
5.7
3 freelancers are bidding on average $15 USD for this job
User Avatar
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 in 0 day
4.9 (136 reviews)
6.3
6.3

About the client

Flag of UNITED STATES
Brookline, United States
5.0
1
Payment method verified
Member since Nov 20, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.