mysql average from two table

Lovely Lapwing answered on January 9, 2022 Popularity 3/10 Helpfulness 2/10

answer mysql average from two table

Comment

select (sum(s.depth)+sum(l.depth))/(count(s.name)+count(l.name))
from seas s, lakes l

Popularity 3/10 Helpfulness 2/10 Language sql

Tags: average mysql sql

Link to this answer
Share Copy Link

Contributed on Jan 09 2022

Lovely Lapwing

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.