SELECT
t.room_id as room_id,
Users.name,
Reservations.end_date
from
(select room_id, MAX(end_date) as end_date from Reservations group by room_id) as t
join Reservations on t.room_id = Reservations.room_id and t.end_date = Reservations.end_date
join Users on Users.id = Reservations.user_id ;
import pandas as pd
df = pd.DataFrame({"friends": ["Сергей", "Соня", "Дима", "Алина", "Егор"]})
print('У тебя '+ str(df.nunique().friends) + ' друзей')
bikes[bikes['Holiday'] == 'Holiday'][['Date','Holiday']]
in_array(mixed $needle, array $haystack, bool $strict = false): bool
strripos(string $haystack, string $needle, int $offset = 0): int|falsearray_reduce(array $array, callable $callback, mixed $initial = null): mixed
array_map(?callable $callback, array $array, array ...$arrays): array
with в скобках я бы сдвинул на таб вправо, и странные запятые в начале строк убрал бы взад.inner join вправо на таб вместе с on- потому что оно вместе с первой таблицей является подуровнем from.with sum_bon as
(
select
worker_ref_id,
employee_title,
sex,
sum(bonus) as sbon
from
sf_employee as sfe
inner join sf_bonus as sfb
on sfe.id=sfb.worker_ref_id
group by
employee_title,
sex,
worker_ref_id
)
select
sum_bon.employee_title,
sum_bon.sex,
avg(sfe.salary+sbon) compensation
from
sf_employee as sfe
inner join sum_bon
on sfe.id=sum_bon.worker_ref_id
group by
sum_bon.employee_title,
sum_bon.sex
select fid, result, time
from tbl where time in (select max(time) from tbl group by fid)
order by fid