Write a $3$:

Panasonic

cell.

MEADSET

$6.$ Write a SELECT statement that returns these column names and data from the Students table: FirstName The FirstName column

LastName The LastName column

EnrollmentDate The EnrollmentDate column

CurrentDate The current date

MonthsAttended A column that's calculated by getting the difference between the enrollment date and the current date

To get the value of the months attended, use the DATEDIFF function with the month argument. Sort the result set in ascending sequence by the MonthsAttended column.

$7.$ Write a SELECT statement that returns these column names and data from the Instructors table:

FirstName

The FirstName column

LastName

The LastName column

Annualsalary

The AnnualSalary column

Return only the top $20$ percent of instructors based on annual salary.

$8.$ Write a SELECT statement that returns these column names and data from the Students table:

LastName

The LastName column

FirstName

The FirstName column

Return only the rows where the LastName column starts with the letter $\text{'}G\text{'}.$ To do that, use the LIKE phrase.

Sort the result set by last name in ascending sequence

$9.$ Write a SELECT statement that returns these column names and data from the Students table

in$?$ Accessibility, Unavailable

E

$$

C$.$

w

$$

MacBook Pro

F$3$

F$4$

F$5$

F$6$

F$7$

F$8$

F$9$

#

$

$\%$

${?}^{{?}^{?}}$

$6$

&

I

$3$

$4$

$5$

$7$

$8$