Assignment
PostgreSQL Practice #8
-
University
California State University Course
IS 441 | Database Management SystemsPages
2
Academic year
2023
-
Alicia Webb
Views
0
12/09/2023 Answer this question below. 1. Make a SQL Query to display category film with the highest rental count Answer : SELECT c.name, count(r.rental_id) as rental_count FROM category c LEFT JOIN film_category fc ON c.category_id = fc.category_id LEFT JOIN film f ON fc.film_id = f.film_id LEFT JOIN inventory i ON f.film_id = i.film_id LEFT JOIN rental r ON i.inventory_id = r.inventory_id GROUP BY 1 ORDER BY 2 DESC LIMIT 5 Here’s the output when we run the query : 2. Make a SQL Query to display 10 customers who always returned film late. Answer : SELECT c.customer_id, c.first_name, c.last_name, count(*) AS late_return_count FROM customer AS c JOIN rental AS r ON c.customer_id = r.customer_id WHERE r.return_date > r.rental_date GROUP BY c.customer_id, c.first_name, c.last_name ORDER BY 4 desc
LIMIT 10 Here’s the output when we run the query :
Comments
Related Documents
- DAT 102 Module 1
- PostgreSQL Practice #9
- PostgreSQL Practice #6
- 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 #8
Recommended Documents
New Documents from this Uni
Please or to post comments