SQL Operators and Functions

Given the database description below:

Tb$\_$Supplier$($Supp$\_$ID$,$ Name, City$)$

Tb$\_$Consumer$($Con$\_$ID$,$ Name, City$)$

Tb$\_$Product$($Prod$\_$ID$,$ Name, MU$)$

Tb$\_$Offers$($Supp$\_$ID$,$ Prod$\_$ID$,$ Quantity, Price$)$

Tb$\_$Requests$($Con$\_$ID$,$ Prod$\_$ID$,$ Quantity, Price$)$

Tb$\_$Transactions$($T$\_$ID$,$ Supp$\_$ID$,$ Con$\_$ID$,$ Prod$\_$ID$,$ Quantity, Price$)$

Solve and test the following queries:

$1)$ Name of suppliers located in cities having $$C$$ as initial?

$2)$ Name of products with name having $$A$,$C$$ or $$O$$ as initial?

$3)$ Name of products with name ending with $$e$$ or $$l$?$

$4)$ Name of consumers starting with $$W$$ and not ending with $$a$,$c$,$d$,$e$,$f$,$g$,$

$$l$,$m$,$n$$ or $$o$.$

$5)$ Names of suppliers not starting with $$A$$ or $$J$$ and having $$a$$ in the third position?

$6)$ Name of suppliers located in a city not having $$C$$ as initial and offering products

with name having $$O$$ as initial.

$7)$ Find the number of days until the end of the year?

$8)$ Tell what day of the week will be your $50$th birthday $(2$ columns: date of birth,

day of week for $50$th birthday$)?$

$9)$ Tell the equivalent in days, in hours and in minutes of your age?

$10)$ Return the current date as in this sample: $$Monday$,$ November $15,2021.$