Part $1$: Draw the result set $($table$)$ that will result from each of the following queries. Be sure to include column headings.

Uses Sample Database $1$

SELECT sname AS name, age FROM sailors

WHERE age $>=50$

ORDER BY name;

English translation of query:

$$Show the name and age for all sailors at least $50$ years old, ordered alphabetically.$$

Uses Sample Database $1$

SELECT sname, rating FROM sailors

ORDER BY rating DESC, name ASC LIMIT $5$;

English translation of query:

Uses Sample Database $1$

SELECT $*$ FROM reservations

WHERE date BETWEEN $\text{'}2023-11-01\text{'}$ AND $\text{'}2023-11-30\text{'}$;

English translation of query:

Uses Sample Database $2$:

SELECT lname$,$ fname, address

FROM employee

WHERE address NOT LIKE $\text{'}\%,$ Houston, TX$\text{'}$;

English translation of query:

Uses Sample Database $2$:

SELECT pname AS houston$\_$products FROM project

WHERE pname LIKE 'product$\_\text{'}$ AND location $=$ 'Houston';

English translation of query:

Uses Sample Database $2$:

SELECT fname, lname$,$ salary $+$ salary $*0\mathrm{.}1$ new$\_$salary

FROM employee

WHERE dno IN $(1,5)$

ORDER BY new$\_$salary;

English translation of query: