$--$Using the Movie Database write the SQL queries to satisfy the following. Submit this file with your SQL anwsers via D$2$L

$--$Q$1.$ List the member #$,$ name $,$ city and province for all members

$--$Q$2.$ List the id $,$ name $,$ gender and birth date for all actors

$--$Q$3.$ List the dvd no$,$ title, category and year of release for all movies whose nominations are at least $3$ but are no more than $6$

$--$Q$4$ List the details for all Horror movies that have over $2$ awards

$--$Q$5.$ List the details for all movies whose category is either Horror or Comedy

$---$Q$6.$ List the details for all movies whose category is either Comedy or Horror and who also have over $2$ awards

$--$Q$7.$ List details for all movies except those whose category is either Action or Sci$-$Fi

$--$Q$8.$ List the details for all Comedy movies. Sequence the output by title within year of release i$.$e$.$ year of release is the major key

$--$Q$9.$ List the details for all members in Toronto with osfines of at least $$3.$ Sequence the output from the highest to lowest fine amount

$--$Q$10.$ List the details for all movies whose category is either Comedy or Horror, and who also have a over $4$ nominations and at least $2$ awards.

$--$ Sequence the output by title within category