Advertisement
Guest User

Untitled

a guest
Apr 19th, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. #11
  2. SELECT name
  3. FROM (
  4.         SELECT * FROM reservation r
  5.         JOIN entity e ON e.client_id = r.client_id
  6.     )s
  7. WHERE to_date('17-04-2019', 'DD-MM-YYYY')>arrival_date AND to_date('19-04-2019', 'DD-MM-YYYY')<departure_date
  8. GROUP BY s.name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement