Question: Language: SQL Pseudocode (SELECT, GROUPBY and JOIN) The following three data tables describe the authors/clients, book titles, and sales to publishers for a certain literary

Language: SQL Pseudocode (SELECT, GROUPBY and JOIN) The following three data tables describe the authors/clients, book titles, and sales to publishers for a certain literary agency:

clients

cid first_name last_name sign_date agent
jsmith Jane Smith 2001-03-04 Nelson
adory April Dory 2001-03-04 Paige
shu Simon Hu 2003-01-29 Paige
jsmith2 Jane Smith 2006-11-09 Nelson
lortiz Lorena Ortiz 2010-09-26 Nelson

titles

title author genre word_count
The House on the Hill jsmith contemporary 106789
The Blue Diary jsmith contemporary 95019
Dragon Eaters adory fantasy 135501
Silent Wizards adory fantasy 126038
Forbidden Alchemy adory fantasy 111666
My Fathers Piano shu memoir 101365
Blueberry Pastures jsmith2 contemporary 95019
Sudden Confinement jsmith2 horror 95134
Rubi Saves the World lortiz young adult 76045

sales

title rights advance royalty
The House on the Hill domestic first print 15000 0.125
Dragon Eaters domestic first print 12000 0.100
Dragon Eaters foreign markets 5000 0.050
Dragon Eaters audio 4000 0.075
Blueberry Pastures domestic first print 15000 0.125
My Fathers Piano domestic first print 14500 0.100
My Fathers Piano foreign markets 14500 0.100
Rubi Saves the World domestic first print 13500 0.110
Rubi Saves the World audio 6000 0.060

Question: Rank the genres from largest advances to smallest advances, using the average advance from domestic first print rights. Provide a SQL-style pseudocode strategy (using relational data concepts such as SELECT, WHERE, GROUP BY, and JOIN) for solving the problem.

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:

Language: SQL Pseudocode (SELECT, GROUPBY and JOIN) The following three data tables describe the authors/clients, book titles, and sales to publishers for a certain literary agency: clients cid...

Q:

Language: SQL Pseudocode (SELECT, GROUBY and JOIN) The following three data tables describe the authors/clients, book titles, and sales to publishers for a certain literary agency: clients cid...

Q:

For the EMPLOYEE table on page 10, show the output of the following Structured Query Language (SQL) query: SELECT COUNT(*) AS Total, STORE_CODE FROM EMPLOYEE WHERE EMP_LNAME Like '%on' GROUP BY...

Q:

and this is question 1 1. (10 points) Write a relational algebra plan for the following SQL query: SELECT a.p FROM person_living AS a, male AS b WHERE a.p b.name AND NOT EXISTS (SELECT* FROM parent...

Q:

What is the purpose of the AS clause in SQL? It defines a search condition It assigns aliases to tables, columns, or calculations It is used in INNER JOIN to join two tables Neither of the other...

Q:

Here is the schema: -- Sakila Sample Database Schema -- Version 1.0 -- Copyright (c) 2006, 2015, Oracle and/or its affiliates. -- All rights reserved. -- Redistribution and use in source and binary...

Q:

16. The external model yields some advantages such as ______________ a. use of the database subsets to make application program development much simpler. b. use of the database subsets to make...

Q:

Question: Build a SELECT that lists the unique rental rates across all films. Expected Result Set Size: 3 Rows Here is the schema used: -- Sakila Sample Database Schema -- Version 1.0 -- Copyright...

Q:

Using JFlex and JCup tools, build the lexical analyser and parser for the SQL-subset language. Wrap the parser within an interactive program that behaves as follows: $ java OurSQL SQL>select pno,...

Q:

Page 1 of 4 SQL Assignment ACCTG 333 - Fall 2019 Professor Perols Due Friday, November 8, 2019 Why should you learn SQL? Technology is drastically changing the accounting industry...and structured...

Q:

One criticism of Rand and Nietzsche is that they are attacking a view (an extreme altruism) that no one really holds. Do you think this is true? If you think Rand and Nietzsche have a point in...

Q:

During a move, Kate and Lou have to push Kate's 80-kg stove up a rough loading ramp, pitched at an angle of 10, to get it into a truck. They push it along the horizontal floor to pick up speed and...

Q:

Question 4 0 . 5 pts In order to maximize diversification benefits, an investor should add a security with a correlation to the existing closest to: - 0 . 6 0 0 4

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

Suppose government spending increases. Would the effect on aggregate demand be larger if the Federal Reserve took no action in response or if the Fed were committed to maintaining a fixed interest...

Q:

Suppose that people suddenly wanted to hold more money balances. a. What would be the effect of this change on the economy if the Federal Reserve followed a rule of increasing the money supply by 3...

Q:

Suppose the federal government cuts taxes and increases spending, raising the budget deficit to 12 percent of GDP. If nominal GDP is rising 5 percent per year, are such budget deficits sustainable...