SQL Queries

-
use classicmodels;
select *
from products
inner join productlines
using(productLine);
 
select *
from products
left join productlines
using(productLine);

select *
from products
left join productlines
using(productLine);

select productCode,productName,image
from products
left join productlines
using(productLine);

select productCode,productName,image
from products
left join productlines
using(productLine)
where productCode like '%20%';

select productCode,productName,quantityInStock,image
from products
left join productlines
using(productLine)
order by quantityInStock desc;

select productCode,productName,quantityInStock,image
from products
left join productlines
using(productLine)
order by quantityInStock desc
limit 10;

select *
from products
inner join productlines
using(productLine)
where productLine='Classic Cars'
order by quantityInStock desc
limit 10;

select *
from products
inner join productlines
using(productLine)
where productLine='Classic Cars' and productName like '200%'
order by quantityInStock desc
limit 10;

Comments

Post a Comment

Popular posts from this blog

SQL Queries

-
 Hello guys! Today, I practiced SQL Queries in  SQLZoo . SELECT population FROM world WHERE name = 'Germany' SELECT name, population FROM world WHERE name IN ('Sweden', 'Norway','Denmark') SELECT name, area FROM world WHERE area BETWEEN 200000 AND 250000; SELECT name FROM world WHERE population >= 200000000 SELECT name,(population/1000000) as population FROM world WHERE continent='South America' SELECT name,population FROM world WHERE name IN('France', 'Germany', 'Italy') SELECT name FROM world WHERE name LIKE 'United%' SELECT name, population, area FROM world WHERE area>3000000 AND population>250000000
Read more

SQL Queries

-
Image
use sql_store; Select * from customers; insert into customers values (default,'Janani','P',null,null,'RVS','MPL','AP',default); insert into customers values (default,'Lalitha','V',null,null,'MPL','MPL','AP',570), (default,'Vyshu','V',null,null,'Kadapa','Kadapa','AP',670), (default,'Sandhya','G',null,null,'GVP','MPL','AP',590); select * from products; insert into products values (default,'Appliances-Fans',30,5.30), (default,'Appliances-Kettles',35,4.63);
Read more

SQL Queries

-
Hello guys! Today, I practiced SQL Queries in  SQLZoo SELECT SUM(population) FROM world SELECT DISTINCT(continent) FROM world SELECT SUM(gdp) FROM world WHERE continent='Africa' SELECT COUNT(name) FROM world WHERE area>=1000000 SELECT SUM(population) FROM world WHERE name IN('Estonia', 'Latvia', 'Lithuania') SELECT continent,COUNT(name) FROM world GROUP BY continent SELECT continent,COUNT(name) FROM world WHERE population>=10000000 GROUP BY continent SELECT continent FROM world GROUP BY continent HAVING SUM(population)>=100000000
Read more