SQL – Group By – SQL and Python

-- More than one condition in more than one column
-- Use one set of conditions or another. The OR operator.
Select longitude,latitude,housing_median_age
From tablename
Where housing_median_age = '30.000000'
And latitude >= '38.000000'
Or
housing_median_age = '40.000000'
And latitude >= '38.000000'

-- Count and Group By housing_median_age
Select Count(*),housing_median_age
From tablename
Where housing_median_age = '30.000000'
And latitude >= '38.000000'
Or
housing_median_age = '40.000000'
And latitude >= '38.000000'
Group By housing_median_age