xPtv45z
-
Posts
650 -
Joined
-
Last visited
Community Answers
-
xPtv45z's post in group by izlaiž rezultātu was marked as the answer
To query iespējams uzrakstīt daudz vienkāršāku un ātrāku (sqlfiddlā uz tiem ierakstiem, 2ms pret 31ms)
SELECT `person`.`name`, round(avg(`vehicle`.`cost`)) AS `avg_car` FROM `person` LEFT OUTER JOIN `vehicle` ON `person`.`id` = `vehicle`.`person_id` AND `vehicle`.`vehicle` = 'car' GROUP BY `person`.`id` -
xPtv45z's post in Fonta nomaiņa. was marked as the answer
@import url(http://fonts.googleapis.com/css?family=Cuprum:400,700&subset=latin,latin-ext,cyrillic); Nepalīdz?