where billingCountry = "Germany" or billingCountry = "France" or billingCountry = "USA";
chinook.db
select *
from invoices
where billingCountry = "Germany" and billingCity <> "Berlin";
chinook.db
select *
from invoices
where billingCountry = "France" and billingCity <> "Paris";
chinook.db
select InvoiceDate as Date, CustomerId, Total
from invoices
where Date between '2010-01-01' AND '2012-01-01';
chinook.db
select invoiceDate as dates, customerId, total
from invoices
where dates between '2010-01-01' and '2011-01-01';
chinook.db
select Name, milliseconds
from tracks
where milliseconds between 250000 and 300000 or milliseconds between 350000 and 400000;
chinook.db
select FirstName, LastName, Title
from employees
where Title in ('General Manager', 'Sales Manager', 'IT Manager');
chinook.db
select *
from invoices
where BillingCountry in ('Germany', 'France', 'USA');
chinook.db
select invoiceId, InvoiceDate, Total
from invoices
where BillingCountry in ('USA', 'Canada') and total > 8;
chinook.db
select title, count(title) as numEmployees
from employees
group by title;
chinook.db
select total, billingcountry
from invoices
group by billingcountry;
chinook.db
Type SQL, then Shift-Enter. Ctrl-space for more options.
chinook.db
select billingcountry, total as totalsales
from invoices
group by billingcountry
order by totalsales desc
chinook.db
--your code goes here
chinook.db
--your code goes here
chinook.db
select artists.name, albums.title
from artists
inner join albums on artists.artistid = albums.artistid
order by artists.name asc;
chinook.db
--your code goes here
chinook.db
Type SQL, then Shift-Enter. Ctrl-space for more options.
chinook.db
--your code goes here
chinook.db
Type SQL, then Shift-Enter. Ctrl-space for more options.
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.