<ol class="editor-list-ol" dir="ltr"><li value="1" class="editor-listitem">SELECT COUNT(*) FROM film WHERE length &gt; (SELECT AVG(length) FROM film);</li><li value="2" class="editor-listitem">SELECT COUNT(*) FROM film WHERE rental_rate = (SELECT MAX(rental_rate) FROM film);</li><li value="3" class="editor-listitem">SELECT * FROM film WHERE rental_rate = (SELECT MIN(rental_rate) FROM film) AND replacement_cost = (SELECT MIN(replacement_cost) FROM film);</li><li value="4" class="editor-listitem">SELECT payment.payment_id, payment.customer_id, payment.amount, customer.first_name, customer.last_name FROM payment INNER JOIN customer ON payment.customer_id = customer.customer_id WHERE amount = (SELECT MAX(amount) FROM payment);</li></ol>

SQL Ödev 12

Comments