This query is used to properly display the entire record of a customer.

\begin{lstlisting}
SELECT
    customerID,
    CONCAT(first_name, ' ', middle_initial, ' ', last_name) AS name,
    CONCAT(
        apt_number, ', ', street_name, ', ', city, ', ',
        state, ' - ', zip, ', ', country
    ) AS customer_address,
    age,
    ph.num as primary_phone_number,
    email
FROM
    customer,
    address,
    (
        SELECT num FROM phone_number, customer
        WHERE phone_number.phoneID = customer.phoneID
        AND customerID = 50 LIMIT 1
    ) AS ph
WHERE customer.addressID = address.addressID AND customer.customerID = 50;
\end{lstlisting}