-
Notifications
You must be signed in to change notification settings - Fork 0
/
unit3_cheatsheet.html
52 lines (52 loc) · 2.1 KB
/
unit3_cheatsheet.html
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
<!DODTYPE html>
<head>
<title>SQL Cheetsheet</title>
<link rel="stylesheet" type="text/css" href="stylesheets/my_style.css">
</head>
<body>
<header>
<h1>SQL Cheetsheet</h1>
<h3 id="date">May 4, 2014</p>
</header>
<main>
<article class="blog">
<h2>SELECT</h2>
<div class="example">
<p>SELECT population FROM world WHERE name='GERMANY'</p>
</div>
<p>Using a mathimatical operator...</p>
<div class="example">
<p>SELECT name, area FROM world WHERE area <span class="bold">></span> 50000</p>
</div>
<p>Using <span class="bold">AND</span>...</p>
<div class="example">
<p>SELECT name, continent FROM world WHERE area < <span class="bold">AND</span> dgp > 50000</p>
</div>
<p>Using <span class="bold">IN</span>...</p>
<div class="example">
<p>SELECT name, polulation FROM world WHERE name <span class="bold">IN</span> ('Finland', 'Norway', 'Denmark', 'Sweden')</p>
</div>
<p>Using <span class="bold">LIKE</span> and <span class="bold">%</span>...</p>
<div class="example">
<p>SELECT name FROM world WHERE name <span class="bold">LIKE</span> "D<span class="bold">%</span>"</p>
</div>
<p>Using <span class="bold">BETWEEN</span>...</p>
<div class="example">
<p>SELECT name, area FROM world WHERE area <span class="bold">BETWEEN</span> 207600 AND 244820</p>
</div>
<p>Using <span class="bold">LENGTH</span> and <span class="bold">COUNT</span>...</p>
<div class="example">
<p>SELECT name, <span class="bold">LENGTH</span>(name) FROM world WHERE <span class="bold">LENGTH</span>(name) = 5</p>
<p>SELECT <span class="bold">COUNT</span>(subject) FROM nobel WHERE subject = 'Chemistry'</p>
</div>
<p>Using <span class="bold">NOT IN</span>...</p>
<div class="example">
<p>SELECT COUNT(DISTINCT yr) FROM nobel WHERE yr <span class="bold">NOT IN</span> (SELCT DISTINCT yr FROM nobel WHERE subject = 'Medicine'</p>
</div>
</article>
<p id="back"><a href="http://smileyface525.github.io">Go back to the main page</a></p>
</main>
<footer>
<p id="footer">Created by Eiko Seino</p>
</footer>
</body>