6E7F6R43

11)
2select first_name, last_name, substr(first_name, 1, 1) || substr(last_name, 1, 3) || '@gmail.com'
3from members
4
52)
6select lower(first_name) || ' ' || upper(last_name)
7from members
8where MEMBER_ID between 140 and 170
9
103)
11select last_name || ' is ' || LENGTH(last_name) || ' digits long' EMPLOYESS
12from members
13
144)
15select 
16first_name AS "FIRST Name",
17last_name AS "Last Name",
18to_char(hire_date, 'dd') DAY,
19to_char(hire_date, 'MM') MONTH,          
20to_char(hire_date, 'YYYY') YEAR
21from members
22
235)
24select first_name, salary, '03' || '.' || TO_CHAR(add_months(hire_date, 1), 'MM.YYYY')
25from members
26ORDER BY salary DESC
27
286) ********************
29select last_name || ' 20 amziuje'
30from members
31where hire_date < '2000.01.01'
32
337)
34select first_name, last_name, job_id, department_id
35from members
36WHERE ROWNUM < 11;
37
38
39select first_name, FLOOR(MONTHS_BETWEEN(SYSDATE, hire_date) / 12) || ' Years' || ' ' || (FLOOR(MONTHS_BETWEEN(SYSDATE, hire_date)) - FLOOR(MONTHS_BETWEEN(SYSDATE, hire_date) / 12) * 12) || ' Months'
40from members
41
429)
43select last_name
44from members
45where mod(length(last_name), 2) = 1
46
4710)
48select last_name, to_char(hire_date, 'dd.Month.yyyy')
49from members
50where substr(lower(to_char(hire_date, 'Month')), 2, 1) = 'a'