Q1 How many books are there in the Computer category? Use column alias for a column with the number of books, show category and the number of books in your report.Q2 Find out how many books each author wrote. Display author’s first and last name and how many books (s)he wrote. Sort by last name, then first name.Q3 Calculate the total paid for the order 1009. Consider quantity in calculations, some books may be purchased in multiple copies.Q4 Find the average retail price of books in each of the Children and Business categories, use a single query to show the average for Children and Business books (two records in the results).Q5 List customers from New Jersey and Florida who placed orders totaling over $30.Aggregate PER order, PER customer.Q6 Determine the average of ALL orders. Find the total per each order before calculating the average for all orders. Hint: Use nesting.Q7 Show the most expensive book a customer from Georgia bought. Assign a clear header to this column.Q8 How much is the least expensive book written by Smith? Combine author's first and last name in one column in the report.Attach and submit your completed assignments in RTF, TXT or SQL format. Please do not include any results from your queries.ONLY submit the SQL scripts using the following naming convention: HW#_Q#_YourInitials.For example:HW5_Q1_DV

I am stuck on how to code this project correctly. Please help provide the correct code with notes.

In this programming assignment, you will be building your very own connect-four computer game. It will let a user play against a computer AI (Artificial Intelligence), which you can make as complex as you like. As a challenge, your AI will be pitted against that of your classmates in a connect-four tournament. This PA will introduce you to 2D arrays, searching through arrays and lets you practice implementing more complex logic.