write SQL queries to for the following tasks:

(More aggregation with grouping) Download, save, and open the database bookstore‐2000.mdb from the website. This database is a somewhat more complicated retail database than our plumbing database. The price actually charged the customer is the cost_of_ each attribute in the ORDERLINES table, and can be lower than the retail_price attribute in the BOOKS table, reflecting occasional discounts. The database contains a small amount of redundancy, in that cost_line in the ORDERLINES table is always equal to quantity*cost_each. Using WHERE to express joins between tables, write SQL queries to for the following tasks:

A.      Show the name of each author, the number of books written by the author (labeled numb_books), the most recent year of publication for such books (labeled most_recent), and their average retail price (labeled avg_price).

B.      For each combination of publisher and year after 1985 for which any books were published, show the publisher name, the year, and the number of books published by that publisher in that year (labeled numb_books).

C.      For each customer, show their customer number, first name, last name, and the total dollar value of discounts they have received; note that the total discounts received is equal to the sum of quantity*(retail_price  –  cost_each), or equivalently the sum of quantity*retail_price  –  cost_line. Note that the total discounts received are zero for most customers. The discounts column should have the heading discounts.

find the cost of your paper

Complete independent research and review two (2) to three (3) online end-user license agreements.

Complete independent research and review two (2) to three (3) online end-user license agreements. Compare and contrast each EULA with each other. In your response, please consider the following: ·….

Write a SQL query that identifies the number of prescriptions grouped by drug name.

ALY6030 Final Project Assignment – Pharmacy Claims Due End of Week 6 Background: The excel file “ALY 6030 Final Project Data Set.xlsx” contains sample pharmacy claims for made-up members of….

Create a JavaFX program to allow a user to query the Northwind database.

Create a JavaFX program to allow a user to query the Northwind database. You should be able to perform the following functionality using the program:   Print order total (not….