vvgsrk

SELECT worker.last_name || ' works for ' || manager.last_name worker_works_for_manager
  FROM employees worker, employees manager
 WHERE worker.manager_id = manager.employee_id;

vvgsrk

SELECT department_id, department_name, location_id, city 
  FROM departments NATURAL JOIN locations;

vvgsrk

SELECT e.employee_id, e.last_name, d.location_id
  FROM employees e JOIN departments d
 USING (department_id); 

vvgsrk

dism.exe /online /enable-feature /featurename:Microsoft-Windows-Subsystem-Linux /all /norestart

vvgsrk

dism.exe /online /enable-feature /featurename:VirtualMachinePlatform /all /norestart

vvgsrk

wsl --set-default-version 2

vvgsrk

sudo apt-get update
sudo apt-get upgrade

vvgsrk

sudo rm /etc/resolv.conf
sudo bash -c 'echo "nameserver 8.8.8.8" > /etc/resolv.conf'
sudo bash -c 'echo "[network]" > /etc/wsl.conf'
sudo bash -c 'echo "generateResolvConf = false" >> /etc/wsl.conf'
sudo chattr +i /etc/resolv.conf

vvgsrk

wsl --install -d Ubuntu-20.04

vvgsrk

WITH product_info AS (
    SELECT
        ROW_NUMBER() over (
            PARTITION BY product_id
            ORDER BY
                __event_ts DESC
        ) AS row_rank,*
    FROM
        {{ ref('src_product_management_product_history') }}
)