Константин Цветков

SELECT time FROM table ORDER BY id LIMIT 1 OFFSET 1

SELECT number_obj, COUNT(number_obj) 
  FROM table_w 
  WHERE `delete`='0' AND date BETWEEN '$date_from' AND '$date_to' 
  GROUP BY number_obj 
  HAVING COUNT(number_obj) > 1

SELECT date, user_id, SUM(hours) FROM user_dolg GROUP BY date, user_id

INSERT INTO galaxy (name, type, diametr FLOAT, mass, discovery_date, birth_date FLOAT, 
  astronomical_object ) 
VALUES (..., (SELECT MAX('id') FROM astronomical_object))

SELECT garages.garage, garages.car AS 1st, garages2dn.car AS 2nd
  FROM garages 
    INNER JOIN garages AS garages2dn ON garages.garage = garages2dn.garage
  WHERE (garages.car = 'niva') AND (garages2dn.car <> 'niva')

SELECT garages.garage, garages.car AS 1st, garages2dn.car AS 2nd
FROM garages 
  LEFT OUTER JOIN garages AS garages2dn 
    ON garages.garage = garages2dn.garage AND garages.ID <> garages2dn.ID
WHERE (garages.car = 'niva')

select MAX(s.salary) from salaries as s
join employees as e on e.emp_no = s.emp_no
where s.to_date = '9999-01-01'
GROUP BY e.gender

AVG( UNIX_TIMESTAMP( IF ( is_close=1, date_end, NOW() ) ) - UNIX_TIMESTAMP( date ) )