structured_query_language_practice/delete_sql_command.sql at main · Polashahmad01/structured_query_language_practice · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
-- SELECT COUNT(*) FROM song;
-- SELECT MIN(year_released), MAX(year_released) FROM song;
-- SELECT DISTINCT year_released FROM song ORDER BY year_released;
-- SELECT COUNT(*) FROM song WHERE year_released = 0;
-- DELETE FROM song WHERE year_released = '0';
-- SELECT COUNT(*) FROM song;
-- SELECT DISTINCT year_released FROM song ORDER BY year_released;
-- SELECT MIN(tempo), MAX(tempo) FROM song;
-- SELECT COUNT(*) FROM song WHERE tempo = 0;
-- DELETE FROM song WHERE tempo = 0;
-- SELECT * FROM song WHERE tempo = 0;
-- SELECT MIN(tempo), MAX(tempo) FROM song;
-- SELECT COUNT(*) FROM song;
-- SELECT MIN(duration), MAX(duration) FROM song;
-- SELECT MIN(loudness), MAX(loudness) FROM song;
-- SElECT COUNT(*) FROM song WHERE loudness > 0;
-- SELECT * FROM song WHERE loudness > 0;
-- DELETE FROM song WHERE loudness > 0;
-- SELECT year_released, ROUND(AVG(tempo)) FROM song GROUP BY year_released ORDER BY year_released;