Question: Using the PUBS database write SQL commands to answer the following: 1. Write a query to list the title, type, and total revenue for all

Using the PUBS database write SQL commands to answer the following:

1. Write a query to list the title, type, and total revenue for all business books that had a revenue greater than $200.

2. Show a list of publisher ids and names, the number of books they published and the revenue they generated by selling their books.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

need 1,7,9 and 10 only please In this assignment, you will write queries for the following database. PART II: The CHINOOK database: The Chinook Database is about an imaginary video and music store....

Q:

Write SQL statements to answer the following questions using Assignment 2s schema (Customer-Invoice-Line-Product-Vendor). (Please see attached images from assignment 2) 1 - Find the count of unique...

Q:

You will need to write SELECT commands to answer the following questions. Print the SELECT command and your results using PHPMYAdmin. Your instructor will give show you how to create the tables. The...

Q:

link for more detail on database below: http://sqlzoo.net/wiki/More_JOIN_operations Data Sciences SQL Test 1. You will have 2 hours to complete this test. At the end of the 2 hours, please send all...

Q:

Suppose a car hire company has a database containing tables called CAR and CAR_STATUS. Each car is represented by the plate number, car make and model, date of registration, body colour, number of...

Q:

Database Management Systems. ( Please give all necessary things). Thanks Question 1: Group by and Aggregates: (read instructions very carefully, understand what is being asked for) (think if asked...

Q:

question 1 Using the chinook database, write SQL SELECT queries to answer the following questions. You need to include your query as well as the result in your answer. a. What is the title of the...

Q:

using mysql command line Mediveron Clinic is a family clinic that provides a wide range of family health services, including advice on health problems, vaccinations, examinations and treatment,...

Q:

Using R Programming, answer the below For the data file, look under "Data" download the movies_merged file, and look at pr1.Rmd (https://piazza.com/gatech/spring2017/cse6242/resources) Answer the...

Q:

Prepare and execute each of the queries listed using the "Adventureworks2012" database in SQL Server. When all of your queries are complete, cut and paste the SQL Syntax into a word document to be...

Q:

The survey of drugstore customers mentioned in Exercise 18 also includes data about staff friendliness. Based on the survey, can Lynda Parks conclude that fewer than 5% of customers rate staff...

Q:

A town plans to borrow about $10 million and is considering three alternatives. At own ofcial requests your guidance on the economic cost of each of the arrangements and advice as to how they would...

Q:

Which of the following ( s ) is / are invalid use of Generics? Choose all invalid use of Generics. E element = new ; E [ list = new E [ 1 1 ] list = new E [ 1 0 0 ] E [ ] list = ( E [ ] ) new Object...

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

Enterprise owners. In view of transition to private control, ownership questions will be open to debate, and will include a combination of state, banking, private and foreign interest. These owners,...

Q:

Management and employees. Motivations and behaviours, and particularly responses to changes, may be critical factors in the ways emerging HRM policies and practices take shape.

Q:

The recent Employment Equity and Skills Development Bills of 1997 are aimed at redressing racial and gender-based employment inequalities, and require companies with more than 50 staff to formulate...