Q$1.$ Create a Student table $(25$ POINTS$).$

StudentID FirstName LastName Email

Using $$ALTER table$$ to create a constraint $($named PK$\_$Student$)$ and define $($StudentID$,$

FirstName$)$ as the composite primary key.

Q$2.$ Fetch all records from OE$.$ORDERS table where the order total is greater than or

equal to $$16000.$ Please paste your code and attach a screenshot of the output. $(25$

POINTS$).$

Q$3.$ Fetch all records from OE$.$ORDERS table where the order total is greater than or

equal to $16000$ and make the records order by order total from lowest to highest value.

$(25$ POINTS$).$

Q$4.$ Fetch records from SH$.$CUSTOMERS table, where customer gender is male, and

the records are ordered by customer country. Only show the column customer ID$,$

Customer first name, and customer last name. Please find the corresponding column

name yourself. $(25$ POINTS$)$