Quelques exemples de Requetes SQL :

- Affiche la liste des emails des personnes s'étant connecté sur RouenWireless? :

select distinct U.email
from connections as C
left join nodes as N on C.node_id = N.node_id
left join users as U on U.user_id = C.user_id
and N.network_id = 'RouenWireless'

- Affiche la liste des emails et le nombre de connexions des personnes s'étant connecté sur RouenWireless? :

select U.email, Count(U.email) As Nb_connexions
from connections as C
left join nodes as N on C.node_id = N.node_id
left join users as U on U.user_id = C.user_id
where N.network_id = 'RouenWireless'
group by U.email