RE:cord

-- 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..

Company Research; SAP 1) Outline   SAP is a German company founded by five engineers who had worked at IBM and its headquarters is in German Walldorf. Their idea was to create standard enterprise software that integrated all business processes and enabled data processing in real time, and it became a reality. SAP established the global standard for enterprise resource planning (ERP) software. SA..

-- 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 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..