SELECT q1, count( q1 ) 
FROM `Quiz` 
GROUP BY q1
ORDER BY q1 ASC 

SELECT q1, count( q1 )*100 /14 AS CORRECT_PERCENT
FROM `Quiz`
GROUP BY q1
HAVING q1 = 'c'

SELECT DISTINCT (SELECT (count( q1 ))
FROM `Quiz`
WHERE q1='c')
+
(SELECT (count( q2 ))
FROM `Quiz`
WHERE q2='c')
FROM `Quiz`

SELECT org, COUNT(org) FROM session GROUP BY org ORDER BY COUNT(org) DESC

SELECT w_direction, COUNT(w_direction) FROM weather GROUP BY w_direction ORDER BY COUNT(w_direction) DESC

SELECT wind_direction, COUNT(wind_direction) FROM seal GROUP BY wind_direction ORDER BY COUNT(wind_direction) DESC

SELECT weather, sum( count_hauled )/count(weather) AS Num
FROM `seal` 
GROUP BY weather
ORDER BY Num DESC

SELECT weather, sum( count_hauled )/count(weather) AS Num
FROM `seal` 
WHERE date(date) > date(2010-10-31)
GROUP BY weather
ORDER BY Num DESC