Find Jobs
Hire Freelancers

Write an SQL query

$10-30 USD

Selesai
Disiarkan lebih dari 5 tahun yang lalu

$10-30 USD

Dibayar semasa penghantaran
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 Projek: 18200388

Tentang projek

3 cadangan
Projek jarak jauh
Aktif 5 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
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 dalam 10 hari
4.9 (37 ulasan)
5.7
5.7
3 pekerja bebas membida secara purata $15 USD untuk pekerjaan ini
Avatar Pengguna
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 dalam 0 hari
4.9 (136 ulasan)
6.3
6.3

Tentang klien

Bendera UNITED STATES
Brookline, United States
5.0
1
Kaedah pembayaran disahkan
Ahli sejak Nov 20, 2018

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.