Start MYSQL Query typing Practice. MYSQL Select Statment, MySql creating Table, Where Clause Typing Practice, MySql Alia and Sub Query statment typing Practice.Click on the area below to start typing.
| S.No. | Paragraph : Practice repeatedly whatever you would like most for full fifteen minutes | Lessions | click to Practice |
|---|---|---|---|
| 1 | SELECT e.firstName, e.lastName FROM employees e ORDER BY e.firstName; SELECT customerName,COUNT(o.orderNumber) total FROM customers c INNER JOIN orders o ON c.customerNumber = o.customerNumber GROUP BY customerName ORDER BY total DESC; SELECT customers.customerName, COUNT(orders.orderNumber) total FROM customersINNER JOIN orders ON customers.customerNumber = orders.customerNumber GROUP BY customerName ORDER BY total DESC; SELECT orderNumber 'Order no.', SUM(priceEach * quantityOrdered) total FROM orderDetails GROUP BY 'Order no.' HAVINGtotal > 60000; | 1.4 | MySQL Alias typing practice |