Advertisement
Frezi2005

Untitled

May 19th, 2019
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.31 KB | None | 0 0
  1. SELECT  
  2.         SUM(`Users`.`age`) AS "Total Age",
  3.         `Users`.`name`,
  4.         `Users`.`surname`,
  5.         `Users`.`driver_license`,
  6.         `Users`.`carRentDate`,
  7.         `Cars`.`id`
  8. FROM
  9.     `Users`
  10. JOIN
  11.     `Cars` ON `Users`.`car_id` = `Cars`.`id`
  12. WHERE
  13.     `Cars`.`id` < 10
  14. GROUP BY `Users`.`age`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement