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

The purpose of this assignment is to examine the components of a research article and help you identify guidelines for conducting critical analyses of published works. The knowledge gained should be applied when completing your weeks 3 and 5 research assignments. As you complete assignments it is a good idea to proof read your work or use the University writing center to help with APA formatting. Both are great avenues for assistance in minimizing grammatical errors and conducting research.Please use the attached “Guidelines for Evaluating a Research Article” to answer the below questions: What is an Information Technology Project? Identify & explain the major parts of a research paper.Explain the difference(s) between qualitative vs quantitative research methods.Why use Peer Reviewed journals?Why are keywords used during the Literature Review process?Why are project deliverables, limitations & deadlines an important aspect of project development?Why use/apply APA Basic Citation Stiles in your writing assignments/research?Why is Academic Integrity important (see syllabus)?Explain the difference between plagiarism vs self-plagiarism?Your assignment must follow these formatting requirements:Use at least three - five (3 - 5 ) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page do not count toward the page count.