vmart_query_03.sql

-- vmart_query_03.sql
-- noncorrelated subquery 
-- Requests female and male customers with the maximum  
-- annual income from customers
SELECT customer_name, annual_income 
FROM public.customer_dimension 
WHERE (customer_gender, annual_income) IN (
  SELECT customer_gender, MAX(annual_income)
  FROM public.customer_dimension
  GROUP BY customer_gender);

Output

  customer_name   | annual_income
------------------+---------------    
 James M. McNulty |        999979
 Emily G. Vogel   |        999998
(2 rows)