mportocarrero

TOP 100 SUCCESSFUL WOMEN IN THE WORLD (FORBES MAGAZINE)

How many women come from which country?

mysql> select country, count(*) from 100women group by country;
+----------------------+----------+
| country              | count(*) |
+----------------------+----------+
| Argentina            |        1 |
| Australia            |        3 |

mportocarrero

Query in MySql:

mysql> select work_2001, bike_2001, work_2011, bike_2011 from cycling where borough = 'Lewisham';
+-----------+-----------+-----------+-----------+
| work_2001 | bike_2001 | work_2011 | bike_2011 |
+-----------+-----------+-----------+-----------+
|    114592 |      2112 |    136057 |      5375 |
+-----------+-----------+-----------+-----------+
1 row in set (0.00 sec)

mportocarrero

Query in MySql:

mysql> select work_2001, bike_2001, work_2011, bike_2011 from cycling where borough = 'Tower Hamlets';
+-----------+-----------+-----------+-----------+
| work_2001 | bike_2001 | work_2011 | bike_2011 |
+-----------+-----------+-----------+-----------+
|     73918 |      2214 |    120873 |      8112 |
+-----------+-----------+-----------+-----------+
1 row in set (0.00 sec)

mportocarrero

Query in MySql:

mysql> SELECT percentage_2001, percentage_2011 from cycling where borough = 'Tower Hamlets' group by borough;
+-----------------+-----------------+
| percentage_2001 | percentage_2011 |
+-----------------+-----------------+
|             3.0 |             6.7 |
+-----------------+-----------------+
1 row in set (0.01 sec)

mportocarrero

Query in MySql:

mysql> SELECT area, count(*) as count from bike where borough = 'Tower Hamlets' group by area;
+------------------------------------------------+-------+
| area                                           | count |
+------------------------------------------------+-------+
| On or near Acton Mews                          |     2 |
| On or near Audrey Street                       |     1 |
| On or near Austin Street                       |     2 |
| On or near Bethnal Green Road                  |     1 |

mportocarrero

Query in MySql:

mysql> SELECT borough, investigation, count(*) from bike where borough = 'Tower Hamlets' group by investigation;
+---------------+--------------------------------+----------+
| borough       | investigation                  | count(*) |
+---------------+--------------------------------+----------+
| Tower Hamlets | No further action at this time |       41 |
| Tower Hamlets | Offender sent to prison        |        1 |
| Tower Hamlets | Suspect charged                |        3 |
| Tower Hamlets | Under investigation            |      113 |

mportocarrero

Query in MySql:

mysql> select borough, date, count(*) as count from bike where borough = 'Tower Hamlets' group by date;
+---------------+------------+-------+
| borough       | date       | count |
+---------------+------------+-------+
| Tower Hamlets | 2013-05-01 |    17 |
| Tower Hamlets | 2013-06-01 |    33 |
| Tower Hamlets | 2013-07-01 |    24 |
| Tower Hamlets | 2013-08-01 |    23 |

mportocarrero

Query in MySql:

mysql> select borough, date, count(*) from bike where borough = 'Tower Hamlets' group by date;
+---------------+------------+----------+
| borough       | date       | count(*) |
+---------------+------------+----------+
| Tower Hamlets | 2013-05-01 |       17 |
| Tower Hamlets | 2013-06-01 |       33 |
| Tower Hamlets | 2013-07-01 |       24 |
| Tower Hamlets | 2013-08-01 |       23 |

mportocarrero

Query in MySql:

mysql> select percentage_2001, percentage_2011 from cycling where borough = 'Lewisham' group by borough;
+-----------------+-----------------+
| percentage_2001 | percentage_2011 |
+-----------------+-----------------+
|             1.8 |             4.0 |
+-----------------+-----------------+
1 row in set (0.01 sec)

mportocarrero

Query in MySql:

2001:

mysql> select borough, bike_2001 from cycling group by borough;
+---------------+-----------+
| borough       | bike_2001 |
+---------------+-----------+
| Croydon       |      1636 |
| Greenwich     |      1351 |