Using the following schema: article | dealer | price | 1 | A 13.45 1| B...

Transcribed Image Text:

Using the following schema: article | dealer | price | 1 | A 13.45 1| B | 3.99 10.99 21 A 3 | B 3 | C 31 D 41 D 1.45 1.69 1.25 19.95 Write a query to produce: 1. display the price, the name of the dealer and the number of the most costly article. 2. Get the most expensive price per article. 3. For each article, locate the dealer or dealers with the most costly price. Using the following schema: article | dealer | price | 1 | A 13.45 1| B | 3.99 10.99 21 A 3 | B 3 | C 31 D 41 D 1.45 1.69 1.25 19.95 Write a query to produce: 1. display the price, the name of the dealer and the number of the most costly article. 2. Get the most expensive price per article. 3. For each article, locate the dealer or dealers with the most costly price.

Answer rating: 100% (QA)

Queries 1 SELECT price dealer article FROM articles WHER... View the full answer