<ol class="editor-list-ol" dir="ltr"><li value="1" class="editor-listitem">SELECT rating, COUNT(*) FROM film GROUP BY rating;</li><li value="2" class="editor-listitem">SELECT replacement_cost, COUNT(*) FROM film GROUP BY replacement_cost HAVING COUNT(*) &gt; 50;</li><li value="3" class="editor-listitem">SELECT store_id, COUNT(*) FROM customer GROUP BY store_id;</li><li value="4" class="editor-listitem">SELECT country_id, COUNT(*) FROM city GROUP BY country_id ORDER BY COUNT(*) DESC LIMIT 1;</li></ol>

SQL Ödev 7

Comments