Structured query language

Data Science, AI and ML
5

can you please solve this question?
here is the link-Structured query language select and group by.