Akina

SELECT DISTINCT
       key,
       FIRST_VALUE(value1) OVER (PARTITION BY key 
                                 ORDER BY CASE WHEN value1 IS NULL 
                                               THEN 1 
                                               ELSE 0 END, id DESC) AS value1,
       FIRST_VALUE(value2) OVER (PARTITION BY key 
                                 ORDER BY CASE WHEN value2 IS NULL 
                                               THEN 1 
                                               ELSE 0 END, id DESC) AS value2,
       FIRST_VALUE(value3) OVER (PARTITION BY key 
                                 ORDER BY CASE WHEN value3 IS NULL 
                                               THEN 1 
                                               ELSE 0 END, id DESC) AS value3
FROM tablename
-- WHERE key IN ( {список значений} )

переписать таблицу в нормальную форму

SELECT `p`.`sum`, `p`.`type`, `p`.`visit` 
FROM `visits` AS `v`
JOIN `payments` AS `p` ON `v`.`id` = `p`.`visit` 
WHERE DATE(p.date) = '2021-10-04' AND `v`.`office` = '1'

SELECT `p`.`sum`, `p`.`type`, `p`.`visit` 
FROM `visits` AS `v`
JOIN `payments` AS `p` ON `v`.`id` = `p`.`visit` 
WHERE p.date >= '2021-10-04' 
  AND p.date < '2021-10-05' 
  AND `v`.`office` = '1'

Например, пишу я такой SELECT и все нормально
SELECT Trip.plane, Trip.id

Но при таком мне выдает ошибку
SELECT Trip.plane, COUNT(Trip.plane) planes

Откуда это берется вообще? /*!40001 SQL_NO_CACHE */ и как это убрать?

SELECT orders.column,
       COALESCE(books.column, deposits.column) AS column
FROM orders 
LEFT JOIN books ON orders.type = 'book' AND orders.id = books.order_id
LEFT JOIN deposits ON orders.type = 'deposit' AND orders.id = deposits.order_id