Question: Consider the tables provided below and answer the following SQL questions: Table 1: Artist Table 2: Track (Traid - means TrackID) traid title 1

Consider the tables provided below and answer the following SQL questions: Table 1: Artist Table 2: Track (Traid - means TrackID) traid title 1 Great Big Words 1 This Pretty Planet 2 Cat's in the Cradle id 1 2 C. name Tom Chapin Harry Chapin d. Questions: a. Write insert statements to enter first two records into Track table as shown in above figure. e. artist b. Display a list that presents the data contained in Track Table sorted by title in ascending order. 1 1 2 Display traid and title for tracks that have 'Pretty' word in middle of the title. Display the name of the artists that belong to the title starting with letter 'C'. Display number (count) of tracks for each artist.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Here are the SQL queries to address your questions a Insert statements to enter the first t... View full answer

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 Programming Questions!

Six samples of n=10 observations have been obtained and the sample means and ranges were computed in minutes: Determine the upper and lower limits for sample mean and range control charts. Is the...

Park Terrace Apartments LLC purchased a 110-story apartment building in Austin, TX. The purchase price was $25,125,000.00. They are allocating 20% of the purchase price towards the value of the land....

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

The matrix A below has Î» = 2 as an eigenvalue. Find the geometric multiplicity of Î» = 2 using your calculator only for row-reducing matrices. 18-15 33 -151 -4 8-6 6 9-16...

Assume The Bike Hub, Inc., bought and sold a line of comfort bikes during July as follows: The Bike Hub, Inc., uses the perpetual inventory system. Requirements 1. Compute the cost of ending...

Of the 361 students who answered the question about the number of piercings they had in their body, 188 had no piercings, 82 had one or two piercings, and the rest had more than two. Construct a...

A random variable X has distribution function F(t) = 0, t Answered: 1 week ago

Marathon, Inc., manufactures two types of shoes: X-Trainer and Court. Last year, Marathon had the following costs and revenues: Marathon, Inc., currently uses labor costs to allocate all overhead,...

Question 8 2 pts \ table [ [ \ table [ [ Quantity ] , [ Demanded ] ] , \ table [ [ Price ] , [ $ ] ] , Total Revenue $ , TR Test ] , [ 2 6 5 , 8 , , x x x x x x

HealthFull Nurse-Run Clinic: Table 6.2 analyzes appointments that are lost (cannot be scheduled) because of limits to capacity. However, another problem at HealthFull Clinic is cancelled...

For a) and b), determine whether each statement is true or false and explain why. a) A statistics professor wanted to test whether the grades on a statistics test were the same for upper and lower...

This week, your assignment is to create a crisis management plan for either your organization or for Dalton, Walton, and Carlton, Inc. When constructing your plan, think about what needs to be done...

1) An altimeter is a device that measures the height of a plane above the ground. It works based on air pressure according to the formula h = 18400log where h is the height above the ground in...

Lets put on our trainer hats and compose a brief training script on critical concepts in legal and ethical issues in the workplace. Select 1 of the following questions. Make sure you define your...

Consider the following series (i) Show that the series converges if (a, b), where a = = (ii) For any I in the above interval the sum of the series is 00 (2x+3)" n=2 2n+1

1. If a generator costing $300k is installed in a factory and the cost of preparing the site is $100k, what would be the QE (qualifying expenditure) for the factory? Korea Manufacturing purchased a...

which one is correct? (4) (p1p3)(p4p3)>0(p2p3)(p4p3)0(p3p1)(p2p1)>0 p1 p4 A)

Walker, Inc., is an all-equity firm. The cost of the company's equity is currently 11.4 percent and the risk-free.rate is 3.3 percent. The company is currently considering a project that will cost...

The data listed in the table on the following page are from an unpublished study by Harbin and others (1985). Subjects were young (ages 18 through 29) or old (ages 60 through 86) men. Each subject...

This problem refers to the pond ecology data of Chapter 5, Problem 20. a. Determine the squared multiple correlation for the regression of copepod count on zooplankton and phytoplankton counts. b....

In Problem 3, the independent variable of interest, copper ion concentration, is an interval-scaled variable. a. Treating copper ion concentration as a five-level categorical predictor (as in the...

Ichiro is checking potential outcomes for the growth of his RRSP. He plans to make contributions of $500 at the beginning of each month. What nominal rate of return must his RRSP earn for its future...

An ordinary annuity and an annuity due have the same present value, n, and i. Which annuity has the smaller payment? Give the reason for your answer.

Gina has $500,000 accumulated in her RRSP and intends to use the amount to purchase a 20-year annuity. She is investigating the size of quarterly payment she can expect to receive, depending on the...