idShura

SELECT
    AVG(value) AS avg_value,
    CASE WHEN  LOWER(TO_CHAR(created_date, 'Day')) = 'monday' THEN 'Понедельник'
         WHEN  LOWER(TO_CHAR(created_date, 'Day')) = 'tuesday' THEN 'Вторник'
         WHEN  LOWER(TO_CHAR(created_date, 'Day')) = 'wednesday' THEN 'Среда'
         WHEN  LOWER(TO_CHAR(created_date, 'Day')) = 'thursday' THEN 'Четверг'
         WHEN  LOWER(TO_CHAR(created_date, 'Day')) = 'friday' THEN 'Пятница'
         WHEN  LOWER(TO_CHAR(created_date, 'Day')) = 'saturday' THEN 'Суббота'
         WHEN  LOWER(TO_CHAR(created_date, 'Day')) = 'sunday' THEN 'Воскресенье'
    END week
FROM results
GROUP BY created_date;

SELECT * FROM FamilyMembers
WHERE member_name LIKE '% Quincey'
ORDER BY status, member_name;

BEGIN;
	DELETE FROM table_1 WHERE ID = 80; 
	DELETE FROM table_2 WHERE ID = 80;
COMMIT;

SELECT E.FIRST_NAME,
       E.LAST_NAME,
       L.STREET_ADDRESS
  FROM HR.EMPLOYEES E
       LEFT JOIN DEPARTMENTS D ON D.DEPARTMENT_ID = E.DEPARTMENT_ID
       LEFT JOIN LOCATIONS L ON L.LOCATION_ID = D.LOCATION_ID;
  
SELECT E.FIRST_NAME,
       E.LAST_NAME,
       L.STREET_ADDRESS
  FROM  HR.EMPLOYEES E
        LEFT JOIN DEPARTMENTS D USING (DEPARTMENT_ID)
        LEFT JOIN LOCATIONS L USING (LOCATION_ID);

select pd.product_id, 
        pd.name 
        pa.price
   from product_description  pd
        left join product_article pa on pa.product_id = pd.product_id

create or replace package inte
as
  c_exact  constant number := 0.99;
end;

 
create or replace trigger t_trigger
before insert on t for each row
begin
        if ( :new.x >= inte.c_exact )
        then
           null;
        end if;
end;

SELECT * FROM Table
WHERE PublishDate between '20201006' AND '20201014'

SELECT * FROM Table
WHERE PublishDate >= DATEADD(day,-7, GETDATE())

$sql 'UPDATE `_spi`
SET `w_st`=`w_t`+`w_s`+`w_z`+`w_p` + CASE WHEN `p_m` =  \'IV\' THEN `w_t`+`w_s` ELSE 0 END';