Write down the SQL statement for both tables provided

a$.$ Create the above$-$mentioned tables. Keep the same name and primary

key.

b$.$ Show the Program and Age of the students who are NOT from

$$Canada$.$

c$.$ Show the Average $($AVG$),$ highest $($MAX$)$ and lowest $($MIN$)$ age from

the student table. Rename the columns using $$AS$$ clause as follows.

Average Age Highest Age Lowest Age

d$.$ Show the course ID and names which contains $$SQL$$ on the name.

$\{$Hint: Use LIKE wildcards$\}$

$1.$ Briefly describe how $$Order By$$ works. Give your own example. You may use ModulerNo, Age or GPA column of Student Table for the example.

$2.$ Is there any way to JOIN the above$-$mentioned Student and Course tables?

How?

Which could be the possible common attributes to join the table?

Write down an example SQL Statement to join them using the joining conditions.