wdbd_lab6

SELECT * FROM `customer`
SELECT * FROM customer;
SELECT * FROM country;
SELECT c.FIRSTNAME, c.LASTNAME FROM customer c WHERE c.FIRSTNAME = "John" ORDER by 2;
SELECT * FROM city;
SELECT c.COUNTRYNAME, c.COUNTRYCODE from country c;
SELECT concat(c.COUNTRYNAME, c.COUNTRYCODE) from country c;
SELECT city.CITYNAME CityFullName from city;
SELECT country.COUNTRYNAME CountryName, country.COUNTRYCODE CountryCode from country;
SELECT oh.ORDERDATE "Order Year" FROM orderheader oh;
SELECT YEAR(oh.ORDERDATE) "Order Year" FROM orderheader oh;
SELECT DISTINCT YEAR(oh.ORDERDATE) "Order Year", MONTH(oh.ORDERDATE) "Order Month" FROM orderheader oh;
SELECT DISTINCT YEAR(oh.ORDERDATE) "Order Year", MONTH(oh.ORDERDATE) "Order Month" FROM orderheader oh ORDER BY 1 DESC, 2 ASC;
SELECT DISTINCT YEAR(oh.ORDERDATE) "Order Year", DAYOFWEEK(oh.ORDERDATE) "Order Month" FROM orderheader oh;
SELECT oh.CUSTOMERKEY FROM orderheader oh WHERE YEAR(oh.ORDERDATE) = 2019;
SELECT DISTINCT oh.CUSTOMERKEY FROM orderheader oh WHERE YEAR(oh.ORDERDATE) = 2019;
SELECT DISTINCT oh.COUNTRYKEY FROM orderheader oh WHERE dayofweek(oh.ORDERDATE) = 7;
SELECT DISTINCT od.PRODUCTKEY FROM orderdetail od WHERE od.TRANSACTIONPRICE = od.CATALOGPRICE;
SELECT DISTINCT oh.CHANNELKEY FROM orderheader oh WHERE dayofweek(oh.ORDERDATE) = 1 OR dayofweek(oh.ORDERDATE) = 7;
SELECT DISTINCT oh.CHANNELKEY FROM orderheader oh WHERE dayofweek(oh.ORDERDATE) IN (1,7);
SELECT p.PRODUCTNAME FROM product p WHERE p.PRODUCTCODE IN ("RF-9198", "CH-0234");
SELECT DISTINCT o.CUSTOMERKEY FROM orderheader o WHERE o.ORDERDATE BETWEEN "2019-07-01" and "2019-09-30";
SELECT DISTINCT o.PRODUCTKEY FROM orderdetail o WHERE o.QUANTITY * o.TRANSACTIONPRICE BETWEEN "1000" and "3000";
SELECT DISTINCT o.PRODUCTKEY FROM orderdetail o WHERE o.QUANTITY * o.TRANSACTIONPRICE BETWEEN "1000" and "3000" ORDER BY o.PRODUCTKEY;
SELECT DISTINCT o.PRODUCTKEY FROM orderdetail o WHERE o.QUANTITY * o.TRANSACTIONPRICE BETWEEN "1001" and "2999" ORDER BY o.PRODUCTKEY;
SELECT DISTINCT p.PRODUCTSUBCATEGORYNAME FROM productsubcategory p WHERE p.PRODUCTSUBCATEGORYNAME like "%Mountain%" ORDER BY p.PRODUCTSUBCATEGORYNAME;
SELECT DISTINCT p.PRODUCTSUBCATEGORYNAME FROM productsubcategory p WHERE p.PRODUCTSUBCATEGORYNAME like "%Helmet%" ORDER BY p.PRODUCTSUBCATEGORYNAME;
SELECT DISTINCT p.PRODUCTSUBCATEGORYNAME FROM productsubcategory p WHERE lower(p.PRODUCTSUBCATEGORYNAME) like "%helmet%" ORDER BY p.PRODUCTSUBCATEGORYNAME;
SELECT DISTINCT c.FIRSTNAME, c.LASTNAME FROM customer c WHERE lower(c.LASTNAME) like "%a" ORDER BY c.LASTNAME;
SELECT DISTINCT c.FIRSTNAME, c.LASTNAME FROM customer c WHERE lower(c.LASTNAME) like "%a" ORDER BY c.LASTNAME;
SELECT c.FIRSTNAME, c.LASTNAME FROM customer c WHERE lower(c.LASTNAME) like "%a" ORDER BY c.LASTNAME;
SELECT concat(c.FIRSTNAME, " ", c.LASTNAME) FROM customer c WHERE lower(c.LASTNAME) like "%a" ORDER BY c.LASTNAME;
SELECT concat(o.ORDERKEY, " " , o.ORDERDATE) FROM orderheader o WHERE o.DELIVERYDATE is null ORDER BY o.ORDERDATE;
SELECT o.ORDERKEY,o.ORDERDATE FROM orderheader o WHERE o.DELIVERYDATE is null ORDER BY o.ORDERDATE;
SELECT DISTINCT o.ORDERKEY,o.ORDERDATE FROM orderheader o WHERE o.DELIVERYDATE is null ORDER BY o.ORDERDATE;
SELECT o.ORDERKEY,o.ORDERDATE FROM orderheader o WHERE o.DELIVERYDATE is null ORDER BY o.ORDERDATE;
SELECT concat(o.ORDERKEY, " ", o.ORDERDATE) FROM orderheader o WHERE o.DELIVERYDATE is null ORDER BY o.ORDERDATE;
SELECT o.ORDERKEY, o.ORDERDATE FROM orderheader o WHERE o.DELIVERYDATE is null ORDER BY o.ORDERDATE;
SELECT o.CHANNELKEY FROM orderheader o WHERE o.COUNTRYKEY = 1 AND YEAR(o.ORDERDATE) = 2019 ORDER BY o.CHANNELKEY;
SELECT o.CHANNELKEY FROM orderheader o WHERE o.COUNTRYKEY = 1 AND YEAR(o.ORDERDATE) = 2019 ORDER BY o.CHANNELKEY;
Rozszerz Wykonaj zapytanie ponownie Edytuj Wyjaśnij Profilowanie Dodaj do zakładek Baza danych : adventure_works Czas zapytania : 19:33:37
SELECT DISTINCT o.CHANNELKEY FROM orderheader o WHERE o.COUNTRYKEY = 1 AND YEAR(o.ORDERDATE) = 2019 ORDER BY o.CHANNELKEY;