Assignment
PostgreSQL Practice #6
-
University
California State University Course
IS 441 | Database Management SystemsPages
2
Academic year
2023
-
Alicia Webb
Views
0
08/09/2023 Answer this question below. 1. Make a SQL Query to display 5 cities with the highest total revenue Answer : select c.city_id, c.city, sum(p.amount) as total_revenue from address a left join city c on a.city_id = c.city_id left join customer c2 on c2.address_id = a.address_id left join rental r on r.customer_id = c2.customer_id left join payment p on r.rental_id = p.rental_id group by c.city_id, c.city having sum(p.amount) is not null order by 3 desc limit 5; Here’s the output when we run the query : 2. Make a SQL Query to show how much amount in the weekend. Answer : select sum(p.amount) from payment p where extract (isodow from p.payment_date) between 6 and 7
Here’s the output when we run the query :
Comments
Related Documents
- DAT 102 Module 1
- PostgreSQL Practice #9
- PostgreSQL Practice #8
- PostgreSQL Practice #5
- PostgreSQL Practice #1
- The Dual Band 5G Antenna
- Distributed Raman Amplifiers
- Photonic Crystal Biosensor for Blood Analysis
- Diagnosing Depression Using Different Approaches
- Enabling Real-time V2V Communication for Traffic Monitoring
- Universal Theoretical Wireless Signal Propagation Prediction Modelling
- Beam Forming Impact on The Next Generation WI
- Superstrate Microstrip Antenna for 5g Wireless Communication Applications
- Underwater Optical CDMA for 5G Communication
- Wireless Technologies for Aviation Safety
- The Quad-band Antenna with Circular Polarization Diversity
- Routing Algorithms for Flying Ad-hoc Networks (FANETs)
- Photonic Crystals for All-Optical Logic Gates
- Fiber Bragg Grating Sensors for Measurement of Strain, Temperature, and Salinity
PostgreSQL Practice #6
Recommended Documents
New Documents from this Uni
Please or to post comments