WPM
100
CPM
100
Errors
0
Time
15Min
Accuracy
100%
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 |