Multiple choice technology programming languages

What id the output of:proc sql; title ’Table JOINED’; select * from fltsuper s, fltdest d where s.Flight=d.Flight; FLTSUPER Flight Supervisor 145 Kang 145 Ramirez 150 Miller 150 Picard 155 Evanko 157 Lei FLTDEST Flight Destination 145 Brussels 145 Edmonton 150 Paris 150 Madrid 165 Seattle

  1. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Kang 145 Brussels 145 Kang 145 Edmonton 145 Ramirez 145 Brussels 145 Ramirez 145 Edmonton 150 Miller 150 Paris 150 Miller 150 Madrid 150 Picard 150 Paris 150

  2. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Ramirez 145 Edmonton 150 Picard 150 Madrid

  3. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Kang 145 Brussels 145 Kang 145 Edmonton 150 Miller 150 Paris 150 Miller 150 Madrid

  4. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Kang 145 Brussels 145 Ramirez 145 Brussels 150 Miller 150 Paris 150 Picard 150 Paris 150 Picard 150 Madrid
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The SQL query performs an inner join between fltsuper and fltdest on Flight. Flight 145 appears twice in both tables (2×2=4 combinations), Flight 150 appears twice in both tables (2×2=4 combinations). The other flights (155, 157 in fltsuper; 165 in fltdest) have no matches and are excluded from the inner join result. The output has 8 rows total. Option A correctly shows the pattern, though it appears truncated at the end.

Keep practicing — related questions