Locais de Oração

Locais de Oração

select *
from planet_osm_point, planet_osm_polygon
where planet_osm_point.amenity = 'place_of_worship' and planet_osm_point.religion is null and planet_osm_polygon.amenity = 'place_of_worship' and planet_osm_polygon.religion is null

Determinar todos os locais de Oração que não têm nome associado.

select *
from planet_osm_point, planet_osm_polygon
where planet_osm_point.amenity = 'place_of_worship' and planet_osm_point.name is null and planet_osm_polygon.amenity = 'place_of_worship' and planet_osm_polygon.name is null

select *
from planet_osm_point, planet_osm_polygon
where planet_osm_point.amenity = 'place_of_worship'
and planet_osm_point.name is null and planet_osm_polygon.amenity = 'place_of_worship' and planet_osm_polygon.name is null
and planet_osm_point.religion is null and planet_osm_polygon.amenity = 'place_of_worship' and planet_osm_polygon.religion is null

O número de locais de Oração que não têm nome.

select count (*)
from planet_osm_point, planet_osm_polygon
where planet_osm_point.amenity = 'place_of_worship'
and planet_osm_point.name is null and planet_osm_polygon.amenity = 'place_of_worship' and planet_osm_polygon.name is null