# question

## Find the model number of the product (PC, laptop, or printer) with the highest price. Result set: model.

Product(maker, model, type) PC(code, model, speed, ram, hd, cd, price) Laptop(code, model, speed, ram, hd, screen, price) Printer(code, model, color, type, price) The table "Product" includes information about the maker, model number, and type ('PC', 'Laptop', or 'Printer'). It is assumed that model numbers in the Product table are unique for all the makers and product types. Each PC uniquely specifying by a code in the table "PC" is characterized by model (foreign key referencing to Product table), speed (of the processor in MHz), total amount of RAM - ram (in Mb), hard disk drive capacity - hd (in Gb), CD ROM speed - cd (for example, '4x'), and the price. The table "Laptop" is similar to that one of PCs except for the CD ROM speed, which is replaced by the screen size - screen (in inches). For each printer in the table "Printer" it is told whether the printer is color or not (color attribute is 'y' for color printers; otherwise it is 'n'), printer type (laser, jet, or matrix), and the price. Exercise: 24 Find the model number of the product (PC, laptop, or printer) with the highest price. Result set: model.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

·
Then please post your solution. If someone else has a similar problem you can show how to solve it.
1 Like 1 ·
·
This question seems like homework. If it is, we will happily help, as long as you do some work beforehand. Please try to solve the question yourself and supply us with what you have managed so far.
0 Likes 0 ·
·
sir...thnx for saying this...i have solved it my own.....
0 Likes 0 ·