Difference between revisions of "MoL Chapter 8 Lab"

From SQLZOO
Jump to navigation Jump to search
(Created page with "<div class='qu'> <div class=imper>List all details from the weather table for stornoway for 1887 so that you can see the NULL value</div> <source lang='sql' class='def'> SELEC...")
 
Line 4: Line 4:
 
SELECT *
 
SELECT *
 
   FROM weather
 
   FROM weather
  WHERE station='stornoway' and yr=1887
+
  WHERE station='stornoway' AND yr=1892
 
</source>
 
</source>
 
<source lang='sql' class='ans'>
 
<source lang='sql' class='ans'>
DESCRIBE goal
+
SELECT *
 +
  FROM weather
 +
WHERE station='stornoway' AND yr=1892
 
</source>
 
</source>
 
</div>
 
</div>

Revision as of 14:38, 22 December 2015

List all details from the weather table for stornoway for 1887 so that you can see the NULL value
SELECT *
  FROM weather
 WHERE station='stornoway' AND yr=1892
SELECT *
  FROM weather
 WHERE station='stornoway' AND yr=1892