My Solution for the exercise on database-week1 based on world database using mysql terminal and console. Main queries and subqueries are made using different keywords including SELECT, FROM, WHERE, AS, LIKE, ORDER BY, AND, JOIN...ON,AVG (for average), MAX (for highest, largest), MIN (for lowest, minimum), SUM (for total), GROUP BY, etc.
My Solution for the exercise on database-week1 based on world database using mysql terminal and console. Main queries and subqueries are made using different keywords including SELECT, FROM, WHERE, AS, LIKE, ORDER BY, AND, JOIN...ON,AVG (for average), MAX (for highest, largest), MIN (for lowest, minimum), SUM (for total), GROUP BY, etc.