SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SELECT C.first_name, C.last_name, C.email, R.rental_date FROM customer C JOIN rental R ON C.customer_id = R.customer_id JOIN inventory I ON R.inventory_id = I.inventory_id JOIN film F ON I.film_id = F.film_id WHERE F.title = 'Frontier cabin' ORDER BY R.rental_date ASC; SHOW STATUS LIKE 'Last_query_cost';

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear