List all data from the AcademicStatus table. Number of rows expected: $3$

$2.$ List number and academicStatusCode for all students who have been

discontinued. List the results in descending order by number. Number of

rows expected: $7$

$3.$ List number and academicStatusCode for all students who have been

discontinued or suspended. List the results in ascending order by number.

Use $<>$ operator as part of your solution. Do not use OR or NOT. Number

of rows expected: $13$

$4.$ List the province code the persons are from, but show each province code

only once $($i$.$e$.,$ no duplicates$).$ List the results in descending order by

province code. Number of rows expected: $5$

$5.$ List the province code the persons are from $($i$.$e$.,$ no duplicates$)$ with the

NULL value excluded in the output. Number of rows expected: $4$

$6.$ List number, last name, first name, city, and country for persons who does

not have a province code assigned. Number of rows expected: $41$

$7.$ List number, last name, first name, city, and country for persons with first

name that starts with $$AND$$ followed by any single character. Number of

rows expected: $2$

$8.$ List all data from the Program table with program name that starts with

$$Computer$.$ Number of rows expected: $3$

$9.$ List the code, acronym and name of the programs with program name that

contains $$coop$.$ Number of rows expected: $4$

$10.$ List all data for students with final mark that is lower than $55.$ Do not

display final mark that is zero. Number of rows expected: $11$

$11.$ List the number, capacity and memory of any room that has a capacity

greater than or equal to $40,$ is a lab, has computers with $4$GB memory, and

is located at the Doon campus. Number of rows expected: $1$

$12.$ List all employees who teach in the School of Trades and Apprenticeship

and are located at the Doon, Guelph or Waterloo campus. Number of rows

expected:$3$