MySQL leftist query, right-click Query, and inline query

Leftist query

SELECT * from a LEFT join B on a.id=b.id;

Right Union query

SELECT * from a RIGHT join B on a.id=b.id;

inline query

Select A.name,b.class from A, b where c.id=b.id;

ORDER BY

Select *from a order by Desc#desc; descending arrangement, ASC ascending order

GROUP BY

Select COUNT (scores) from the group by CALSS;

Having

Select COUNT (scores) from a group by class has count (scores>=70) ORDER by DESC;

MySQL leftist query, right-click Query, and inline query