Exercise 3 (rating)
For Product table, receive result set in the form of a table with columns: maker, pc, laptop, and printer.For each maker, this table must include "yes" if a maker has products of corresponding type or "no" otherwise.In the first case (yes), specify in brackets (without spaces) the quantity of available distinct models of corresponding type (i.e. being in PC, Laptop, and Printer tables).
If the manufacturer has models of some type in the Product table, but none of them is available, then according to the formulation the result should be
Many find a "mistake" in the test solution. Claims are reduced to the following query:
“… specify in brackets (without spaces) the quantity of available distinct models of corresponding type (i.e. being in PC, Laptop, and Printer tables).”
In our case, this means that we need specify in brackets a quantity of distinct models of the personal computer of manufacturer Е in PC table. In terms of SQL(Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management.SQL it means:
|Перевозки по Москве. Погрузка/разгрузка. В любое время|