For the following statements, you are required to form SQL queries and execute them using the GUI client. Then export the result using the name "Query x$.$csv$",$ x being the label of each query. Put all the SQL you formed into a file named "Script.txt$"$ in the same order. Then archive the file as $"5720$project$1-$xxxxxxxxx$.$zip", xxxxxxxxx being your student id$,$ and turn it in on Canvas. The filenames of your result has to follow the instructions exactly or you may get a deduction in your credit.

$1)$ Print every hobby, along with the total number of users that included that hobby in their profile.

$2)$ Print the name and address of all celebrities who are not movie stars.

$3)$ Print a list of every vendor and the number of different advertisements they$$re running, in descending order.

$4)$ Print email, password, name, date$\_$of$\_$birth, kind of all celebrities who are Movie Stars and are following someone.

$5)$ Print the name and email of every celebrity along with their total number of followers if the amount is over $55.$ The contents should be in descending order based on the number of followers$\mathrm{.}6)$ Find all pair of users $($A$,$B$)$ such that A and B have not blurted on a common topic, but user A is following user B$.$ The query should print the names of A and B in that order.

$7)$ Print every location, along with the total amount of blurts, where users made more than $40$ collective blurts. The query should print the name of the location and total amount of user blurts in descending order of the amount of blurts.

$8)$ For each vendor, print the email of its brand ambassador along with the number of users the brand ambassador is following. Your query should print the vendor name, ambassador email, and number of users the ambassador is following. The output should be in descending order according to the numbers of users being followed.

$9)$ Print the following: vendor id$,$ vendor name, vendor ambassador$$s email, and the total number of users that have been shown the ad$($s$)$ from the vendor. Do this for every vendor.