( NOTE : ABOVE ADVANTAGE IS WE CAN DISPLAY ONLY WHAT WE NEED THAT THINGS ONLY WE CAN ADD TO QUERY BUT ALL THE INNER QUERIES ARE EXECUTED BUT WE CAN RESTRICT WHAT DISPLAY IN OUTER SUBQUERY) ...
Write a solution to report the name and bonus amount of each employee with a bonus less than 1000. Return the result table in any order.