Course5

Home   »   Course5

# Default ignored files
/shelf/
/workspace.xml
# Datasource local storage ignored files
/dataSources/
/dataSources.local.xml
# Editor-based HTTP Client requests
/httpRequests/


  
    
    
    
  


  
    


  
    
      
    
  


  
    
  


  
    
    
  
    
  
  
  
    
  
    
    
    
    
  
  
    
      
    
  
  
    
  
  
    
      
      1620176821213
      
    
  
  
    
  
    
      
    
    
    
      
    
    
    
      
    
    
    
      
    
    
  
SELECT * FROM Apartments
WHERE  price >= (SELECT AVG(price) FROM Apartments )
ORDER BY price;
SELECT * FROM cakes ORDER BY calories LIMIT 3;
SELECT name, MIN (cost)
FROM items WHERE name
LIKE  '%boxes of frogs' AND
seller_id IN  (68, 6, 18)

SELECT ct.name,
it
.name

FROM customers
as
 ct, items AS it

WHERE it.seller_id=
ct
.id;
some_column VARCHAR (50)
SELECT customers . address
FROM customers;
SELECT * FROM students WHERE university = 'MIT';
CREATE TABLE(

 id
,

 name
(30),

 PRIMARY KEY (
)

);
SELECT id, name

FROM students WHERE id >= 12;
SELECT * city FROM students;

Leave a Reply

Your email address will not be published. Required fields are marked *