Difficulty 1
T03.001- Code of the articles belonging to a pack.
Difficulty A
T03.002- Numer of pack, name and price of it.
T03.003- Code, name and brand of the articles that belong to any pack.
T03.004- Code of Alicante province
T03.005- Get the code, name and rrp of the articles whose brand starts from S
T03.006- Information about the users whose email is from eps.
T03.009- Email of the users whose postcode is not neither 02012, 02018 nor 02032.
T03.021- Name of the articles whose name cointains the word EOS
T03.022- Type and focal of the lenses that are used in a Canon Camera of any model.
T03.023- Name of the articles whose price is greater than 100 but less or equal to 200.
T03.024- Name of the articles whose prices is greater or equal to 100 but less or equal to 300.
T03.025- Name of the cameras whose brand is not starting by S.
T03.027- Code of the tvs that have an LCD or LED panel
Difficulty B
T03.007- Code, name and resolution of the tvs whose screen is not between 22 and 42.
T03.008- Code and name of the televisions whose panel is LED type and its price is not greater than 1000 euros
T03.010- Code and name of the packs whose belonging articles are known, without duplicates.
T03.011- Is there any article in basket that is out of stock?
T03.012- Code, name and rrp of the compact type cameras?
T03.013- Code, name and difference between rrp and price of articles that have been requested at any order with price distinct to rrp.
T03.014- Number of order, date and name and surnames of users that request the order, for all those orders requested by users with MARTINEZ surname
T03.019- Brands from which there are no televisions in our DB
T03.026- Postal address of the users whose dni ends with B, L or P.
T03.035- Name of the articles that have been selected at any basket with date between 01.11.2010 and 31.12.2010
T03.037- Identifying number of orders in which articles with a price lower than its rrp are included. No duplicates.
Difficulty C
T03.016- Name, brand and resolution of cameras that have been never ordered.
T03.017- Code, name, type and brand of the cameras with brand Nikon, LG or Sigma
T03.029- Name of the televisions with a screen bigger that the one of television with code A0686.
T03.036- Name of the articles that have been selected at any basket by users of the Valencia or Alicante provinces.
T03.038- Number of pack, name and price of it, and code, name and brand of the articles of that pack.