Exercises by difficulty

Español

No order


Difficulty 1


T02B.006- Code, name and retail price of the articles of less than 100€; the output must be code, name,"has a price of",rrp


Difficulty A


T02B.007- DNI, email, name and surnames of the users of the Asturias province (code 33)

T02B.008- All the information (code and name) of the provinces that have users.

T02B.009- All the information (code and name) of the provinces that have users, avoiding duplicates and sorted by name.

T02B.010- Email of the users of Murcia province that have no phone, with a message in the output like "They don't have phone".

T02B.012- Articles that have no brand

T02B.014- Numer of pack, name and price of it.

T02B.015- Code, name and brand of the articles that belong to any pack.

T02B.017- Code, name, brand, rrp and price of the articles requested in order number 1.

T02B.022- Code, sensor and screen of the cameras, if "screen" has a value, descending sorted by code;


Difficulty B


T02B.018- Code, name, brand, rrp and price of the articles requested in order number 1, that are tv

T02B.019- Date and user of the order, code, name, brand, rrp and price of the articles requested in order number 1 that are tv


Difficulty C


T02B.025- Number of pack, name and price of it, and code, name and rrp of the articles of that pack.