-
Notifications
You must be signed in to change notification settings - Fork 10
/
chapter5_solutions.html
41 lines (26 loc) · 786 Bytes
/
chapter5_solutions.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
<!doctype html>
<html>
<head>
<title>Solutions - Advanced Topics</title>
<link rel=stylesheet href="http://fonts.googleapis.com/css?family=Averia+Serif+Libre:300,400">
<link rel=stylesheet href=style.css>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
</head>
<body>
<h1>Solutions - Advanced Topics</h1>
<ol start="37">
<li><p class=answer>Use</p>
<pre>
select count(*) from flight where date is null;
</pre></li>
<li><p class=answer>Use</p>
<pre>
select flight.*, bank_transaction.*
from flight, bank_transaction
where flight.date = bank_transaction.date;
</pre></li>
<li><p class=answer>The corresponding banking details are filled with <em>null</em> values.</p></li>
</ol>
<p><a href="chapter5.html">Back to Tutorial</a></p>
</body>
</html>