sql-practice/northwind.sql at main · k26rahul/sql-practice · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
SELECT
  *
FROM
  Regions;

SELECT
  *
FROM
  Employees;

SELECT
  FirstName,
  LastName
FROM
  Employees;

SELECT
  FirstName,
  LastName
FROM
  Employees
ORDER BY
  LastName;

SELECT
  OrderID,
  OrderDate,
  ShippedDate,
  CustomerID,
  Freight
FROM
  Orders
ORDER BY
  Freight DESC
LIMIT
  5;

SELECT
  FirstName,
  LastName
FROM
  Employees
WHERE
  Title = "Sales Representative";

SELECT
  FirstName,
  LastName
FROM
  Employees
WHERE
  Region IS NOT NULL;

SELECT
  FirstName,
  LastName
FROM
  Employees
WHERE
  FirstName >= "N";

SELECT
  *
FROM
  Categories;

SELECT
  FirstName,
  LastName
from
  Employees;

SELECT
  *
FROM
  Employees;

SELECT
  OrderID,
  Freight,
  (Freight * 1.1) as FreightWithTax
FROM
  Orders
WHERE
  Freight >= 500