+ 11
Is SQL okay to learn?
8 Respuestas
+ 2
SQl ok
+ 5
Post only Programming related questions and doubts please.
+ 3
Easy to learn too
+ 3
You are trying to retrieve from this simple complex query country_name_eng field from country table in ascending order.
+ 2
Sql is best Priya Sharma but. Don't end with basic
+ 2
Jothirani can u explain this
SELECT country.country_name_eng, COUNT(city.id) AS number_of_cities
FROM country
LEFT JOIN city ON country.id = city.country_id
GROUP BY country.id, country.country_name_eng
ORDER BY country.country_name_eng ASC;
+ 2
Yes
+ 2
Yes