Using MySQL Alias To Make The Queries More Readable: Examples

Examples
Sample Database

#1

SELECT 
    CONCAT_WS(', ', lastName, firstname)
FROM
    employees;

#2

SELECT 
    CONCAT_WS(', ', lastName, firstname) AS `Full name`
FROM
    employees;

#3

SELECT 
    CONCAT_WS(', ', lastName, firstname) `Full name`
FROM
    employees
ORDER BY `Full name`;

#4

SELECT 
    orderNumber `Order no.`,
    SUM(priceEach * quantityOrdered) Total
FROM
    orderdetails
GROUP BY `Order no.`
HAVING total > 60000;

#5

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

#6

SELECT 
    customers.customerName, COUNT(orders.orderNumber) total
FROM
    customers
        INNER JOIN
    orders ON customers.customerNumber = orders.customerNumber
GROUP BY customerName
ORDER BY total DESC

Table List

customers

SELECT * FROM customers;

employees

SELECT * FROM employees;

offices

SELECT * FROM offices;

orderdetails

SELECT * FROM orderdetails;

orders

SELECT * FROM orders;

payments

SELECT * FROM payments;

productlines

SELECT * FROM productlines;

products

SELECT * FROM products;

Result