RE:cord

-- 1. join / 2. selectSELECT worker_title, salaryFROM worker JOIN title ON worker.worker_id=title.worker_ref_idWHERE salary >= (SELECT MAX(salary) FROM worker)  -- using LIMITSELECT *FROM workerWHERE salary >= ( SELECT DISTINCT salary FROM worker ORDER BY salary DESC LIMIT 4, 1);-- using DENSE_RANKSELECT first_name, salary, salary_rankFROM (SELECT first_name,salary, DENSE_RANK() OVER..

-- subQ: Only MacBookPro user's data-- mainQ: event name, event freq -> DESC orderSELECT event_name, COUNT(event_name) AS event_freqFROM (SELECT * FROM playbook_events WHERE device = 'macbook pro') AS MBP_userGROUP BY event_nameORDER BY event_freq DESC;    --1.left join with 'host_id'--2.make group by 'nationality'--3.count n_beds of each groups--4. sort avail_beds DESCSELECT nati..

-- Mainquery : SLECT shipment_id, total_weight FROM (subquery) subquery_name WHERE rank=3-- Subquery : SELECT shipment_id, a, b FROM amazon_shipment GROUP BY shipment_id SELECT shipment_id, total_weight, heavy_numFROM( SELECT shipment_id, SUM(weight) AS total_weight, DENSE_RANK() OVER (ORDER BY SUM(weight) DESC) AS heavy_num FROM amazon_shipment GROUP BY shipment_id) rank..

SELECT AVG(no_of_likes) FROM fb_posts;  SELECT education, AVG(salary) FROM google_salaries GROUP BY education;  SELECT * FROM movie_catalogue ORDER BY duration DESC; * Ascending: ORDER BY column / ORDER BY column ASC* Descending: ORDER BY column DESC

SELECT games FROM olympics_athletes_events WHERE age = (SELECT max(age) FROM olympics_athletes_events) UNION SELECT games FROM olympics_athletes_events WHERE age = (SELECT min(age) FROM olympics_athletes_events);   select count(order_id) from shopify_orders;   SELECT worker_id, login_timestamp FROM worker_loginsWHERE login_timestamp BETWEEN '2021-12-13 00:00:00' AND '2021-12-19 23:59:59'; Just i..