$($a$)$ You need to create these two tables in MySQL$,$ import the given data from your second

assignment, and provide a screenshot of the important data. $[1$ point$]$

$($b$)$ Find the total number of rows in PART table and provide the screenshot of SQL query

and its output. $[1$ point$]$

$($c$)$ Find the total number of rows in PARTSUPP table and provide the screenshot of SQL

query and its output. $[1$ point$]$

$($d$)$ Write SQL queries in MySQL and their execution time with screenshots for the following

operations, where $R=$ PART table and $S=$ PARTSUPP table, and fill the following table.

ote: all the above operations will be executed on the common column of both tables.