Advertisement
Guest User

Untitled

a guest
Jun 24th, 2018
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT t.Id AS TripId,act.Luggage, CASE
  2. WHEN act.Luggage < 6 THEN CONCAT('$', 0)
  3. ELSE CONCAT('$', (act.Luggage * 5))
  4. END
  5. AS Fee
  6. FROM Trips AS t
  7. JOIN AccountsTrips AS act
  8. ON act.TripId = t.Id
  9. WHERE act.Luggage > 0
  10. ORDER BY act.Luggage DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement