Urgent help please!

Products

$\backslash$table$[[$Id$,$name,price,Quantity$],[1,$T$-$shirt,$19\mathrm{.}99,50],[2,$Hoodle,$39\mathrm{.}99,25],[3,$Hat,$9\mathrm{.}99,100]]$

$\backslash$table$[[$id$,$Name$],[1,$John Smith$],[2,$Smith Doe$],[3,$Bob Johnson$]]$

Orders

Orders

$\backslash$table$[[$id$,$date,customer$\_$id$],[1,\frac{1}{15}\frac{?}{22},1],[2,\frac{2}{20}\frac{?}{22},1],[3,\frac{2}{25}\frac{?}{22},3]]$

Order Lines

$\backslash$table$[[$id$,$order$\_$id$,$product$\_$id$,$quantity$],[1,1,1,2],[2,2,2,5],[3,2,3,1],[4,3,1,1]]$

Write the results of the following queries:

$\backslash$table$[[\backslash$table$[[1-$SELECT $*$ FROM CUSTOMERs where name$],[$like $\text{'}\%$Smith$\%$:;$]],\backslash$table$[[2-$ SELECT $*$ from Customers WHERE$],[$id not in $($select customer$\_$id from orders$)$;$]]],[\backslash$table$[[3-$SELECT customer.name, count$(*{?}^{**}$ FROM$],[$orders o$,$ customers C WHERE$],[$o$.$customer$\_$id$=$c$.$id GROUP BY$],[$customer$.$name;$]],\backslash$table$[[4-$SELECT p$.$name, avg$($p$-$price $*$ I. quantity$)],[$FROM orders o$,$ order$\_$lines I, Products p$],[$WHERE p$.$id$=$l$.$product$\_$id and I.order$\_$id$=$o$.$id$],[$GROUP BY p$.$name;$]]],[\backslash$table$[[$customer$.$name;$],[5-$ SELECT customer$\_$id$,$ SUM$($I$.$quantity$*$p$.$pri$],[$FROM Orders o$,$ order$\_$line I, products p$],[$WHERE customer$\_$id IN $(]]],[$HAVING COUNT$($DISTINCT order,$]]$

and p$.$id$=$l$.$product$\_$id and l$.$order$\_$id$=$

$0.$id

GROUP BY customer$\_$id;Products

$\backslash$table$[[$Id$,$name,price,Quantity$],[1,$T$-$shirt,$19\mathrm{.}99,50],[2,$Hoodie,$39\mathrm{.}99,25],[3,$Hat,$9\mathrm{.}99,100]]$

$\backslash$table$[[$id$,$Name$],[1,$John Smith$],[2,$Smith Doe$],[3,$Bob Johnson$]]$

Orders

Orders

$\backslash$table$[[$id$,$date,customer$\_$id$],[1,\frac{1}{15}\frac{?}{22},1],[2,\frac{2}{20}\frac{?}{22},1],[3,\frac{2}{25}\frac{?}{22},3]]$

Order Lines

Order Lines

$\backslash$table$[[$id$,$order$\_$id$,$product$\_$id$,$quantity$],[1,1,1,2],[2,2,2,5],[3,2,3,1],[4,3,1,1]]$

Write the results of the following queries:

$\backslash$table$[[\backslash$table$[[1-$SELECT $*$ FROM CUSTOMERs where name$],[$like $\text{'}\%$Smith$\%\text{'}$;$]],\backslash$table$[[2-$ SELECT $*$ from Customers WHERE$],[$id not in $($select customer$\_$id from orders$)$:$]]],[\backslash$table$[[$like $\%$ Smith$\%$;$],[3-$SELECT customer.name, count$(*)$ FROM$],[$orders o$,$ customers c WHERE$],[$o$.$customer$\_$id$=$c$.$id GROUP BY$]],\backslash$table$[[4-$SELECT p$.$name, avg$($p$.$price $*$ I. quantity$)],[$FROM orders o$,$ order$\_$lines I, Products p$],[$WHERE p$.$id$=$l$.$product$\_$id and I.order$\_$id$=0.$id$]]],[$customer$.$name;,GROUP BY p$.$name;$]]$

$5-$ SELECT customer$\_$id$,$ SUM$($I$.$quantity ${?}^{**}p.$price$)$ as total$\_$revenue

FROM Orders $o,$ order$\_$line $1,$ products $p$

WHERE customer$\_$id IN I

SELECT customer$\_$id

FROM Orders

GROUP BY customer$\_$id

HAVING COUNT$($DISTINCT order$\_$id$)>1$

and p$.$id$=$l$.$product$\_$id and I.order$\_$id$=$

o$.$id

GROUP BY customer$\_$id;