Customer Espresso and Cappuccino= 

CALCULATE(

 SUM('Sales Data'[Amount]), , 

 KEEPFILTERS( 'Sales Data'[Product Type] ="Espresso" and 'Sales Data'[Product Type] ="Cappuccino")

myList = ['Python', 'MUO', 'Hello']

myList2 = ["Fish", "Gold", "Bag"]

if len(myList) == 3:

 for items in myList:

  print(items)

else:

 for items2 in myList2:

  print(items2)

SELECT

 e.employee_id AS "Employee #"

 , e.first_name || ' ' || e.last_name AS "Name"

 , e.email AS "Email"

 , e.phone_number AS "Phone"

 , TO_CHAR(e.hire_date, 'MM/DD/YYYY') AS "Hire Date"

 , TO_CHAR(e.salary, 'L99G999D99', 'NLS_NUMERIC_CHARACTERS = ''.,'' NLS_CURRENCY = ''$''') AS "Salary"

 , e.commission_pct AS "Comission %"

 , 'works as ' || j.job_title || ' in ' || d.department_name || ' department (manager: '

 || dm.first_name || ' ' || dm.last_name || ') and immediate supervisor: ' || m.first_name || ' ' || m.last_name AS "Current Job"

 , TO_CHAR(j.min_salary, 'L99G999D99', 'NLS_NUMERIC_CHARACTERS = ''.,'' NLS_CURRENCY = ''$''') || ' - ' ||

 TO_CHAR(j.max_salary, 'L99G999D99', 'NLS_NUMERIC_CHARACTERS = ''.,'' NLS_CURRENCY = ''$''') AS "Current Salary"

 , l.street_address || ', ' || l.postal_code || ', ' || l.city || ', ' || l.state_province || ', '

 || c.country_name || ' (' || r.region_name || ')' AS "Location"

 , jh.job_id AS "History Job ID"

 , 'worked from ' || TO_CHAR(jh.start_date, 'MM/DD/YYYY') || ' to ' || TO_CHAR(jh.end_date, 'MM/DD/YYYY') ||

 ' as ' || jj.job_title || ' in ' || dd.department_name || ' department' AS "History Job Title"


FROM employees e

-- to get title of current job_id

 JOIN jobs j 

 ON e.job_id = j.job_id

-- to get name of current manager_id

 LEFT JOIN employees m 

 ON e.manager_id = m.employee_id

-- to get name of current department_id

 LEFT JOIN departments d 

 ON d.department_id = e.department_id

-- to get name of manager of current department

-- (not equal to current manager and can be equal to the employee itself)

 LEFT JOIN employees dm 

 ON d.manager_id = dm.employee_id

-- to get name of location

 LEFT JOIN locations l

 ON d.location_id = l.location_id

 LEFT JOIN countries c

 ON l.country_id = c.country_id

 LEFT JOIN regions r

 ON c.region_id = r.region_id

-- to get job history of employee

 LEFT JOIN job_history jh

 ON e.employee_id = jh.employee_id

-- to get title of job history job_id

 LEFT JOIN jobs jj

 ON jj.job_id = jh.job_id

-- to get namee of department from job history

 LEFT JOIN departments dd

 ON dd.department_id = jh.department_id

ORDER BY e.employee_id;