PART 1:

Question 1:

The following questions contains real numbers for COVID-19 daily report made on 2020-09-07

Use the CREATE TABLE command and Insert command to create the following table. For each field, pick the most appropriate data type for it.

Give the table name COVID_REPORT and make Country_name as Primary Key.

Country_name	Continent	new_cases	new_deaths	total_cases	total_deaths
Saudi Arabia	Asia	895	32	320827	4081
Bahrain	Asia	676	2	54771	198
United Kingdom	Europe	2988	3	347152	41551
France	Europe	7088	3	324777	30701
Lebanon	Asia	450	4	20426	200

1. Select the country name, cases and from COVID_REPORT table.
2. Use the LIKE operator and write a query to show the country name, population and total deaths of countries belonging to continent ending with letter e.

Output should be as following:

Country_name	Population	Total_deaths
United Kingdom	67886007	41551
France	65273512	30701

3. Select the ISO_Code and new cases of each country.
4. Select the ISO Code and country name that has 30.1 male smoker.
5. Select the number of female and male smokers for countries having 3 new deaths.
6. Produce a relation showing the continent and how many countries in each continent (from the table COVID_Report) ordered by the number of countries in descending order. Hint: use Group By and Order By.