SELECT FROM csv-target

The following SELECT statements demonstrate

Before you begin

SELECT COUNT(*) FROM csv-target;

count (*) |
----------+
  1222997 |

SELECT count(*) AS Male FROM csv-target WHERE gender = 'Male';

   Male |
--------+
9813567 |

SELECT count(*) AS Danish-Female FROM csv-target WHERE gender = 'Female' AND country = 'Denmark';

Danish-Female |
--------------+
       1592   |

SELECT count(DISTINCT occupation) AS occupation FROM csv-target;

occupation |
-----------+
   9314    |