High School

We appreciate your visit to Which of the following PROC SQL steps gives bonuses in points to frequent flyer program members as follows a 50 bonus for members who traveled. This page offers clear insights and highlights the essential aspects of the topic. Our goal is to provide a helpful and engaging learning experience. Explore the content and find the answers you need!

Which of the following PROC SQL steps gives bonuses (in points) to frequent-flyer program members as follows:

a 50% bonus for members who traveled less than 10,000 miles

a 100% bonus for members who traveled 10,000 miles or more?

Select one:

a. proc sql; update work.frequentflyers set pointsearned=pointsearned* case if milestraveled < 10000 then 1.5 if milestraveled >= 10000 then 2 else 1 end;

b. proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then 1.5 when milestraveled >= 10000 then 2 else 1 end; c. proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then pointsearned*1.5 when milestraveled >= 10000 then pointsearned*2 else pointsearned*1 end;

d. proc sql; update work.frequentflyers set pointsearned=pointsearned* case if milestraveled < 10000 then pointsearned*1.5 if milestraveled >= 10000 then pointsearned*2 else pointsearned*1 end;

Answer :

Final answer:

The correct PROC SQL step that gives bonuses to frequent-flyer program members based on their travel distance is option b: proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then 1.5 when milestraveled >= 10000 then 2 else 1 end;

Explanation:

The correct PROC SQL step that gives bonuses to frequent-flyer program members based on their travel distance is option b:

proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then 1.5 when milestraveled >= 10000 then 2 else 1 end;

This SQL statement updates the 'pointsearned' column in the 'work.frequentflyers' table. It uses the CASE statement to check the value of the 'milestraveled' column. If the value is less than 10,000, it multiplies the 'pointsearned' value by 1.5, giving a 50% bonus. If the value is greater than or equal to 10,000, it multiplies the 'pointsearned' value by 2, giving a 100% bonus. If neither condition is met, it multiplies the 'pointsearned' value by 1, which means no bonus is applied.

Learn more about proc sql step for giving bonuses to frequent-flyer program members based on travel distance here:

https://brainly.com/question/32709902

#SPJ14

Thanks for taking the time to read Which of the following PROC SQL steps gives bonuses in points to frequent flyer program members as follows a 50 bonus for members who traveled. We hope the insights shared have been valuable and enhanced your understanding of the topic. Don�t hesitate to browse our website for more informative and engaging content!

Rewritten by : Barada

Final answer:

The correct PROC SQL step that gives bonuses to frequent-flyer program members based on their travel distance is option b: proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then 1.5 when milestraveled >= 10000 then 2 else 1 end;

Explanation:

The correct PROC SQL step that gives bonuses to frequent-flyer program members based on their travel distance is option b:

proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then 1.5 when milestraveled >= 10000 then 2 else 1 end;

This SQL statement updates the 'pointsearned' column in the 'work.frequentflyers' table. It uses the CASE statement to check the value of the 'milestraveled' column. If the value is less than 10,000, it multiplies the 'pointsearned' value by 1.5, giving a 50% bonus. If the value is greater than or equal to 10,000, it multiplies the 'pointsearned' value by 2, giving a 100% bonus. If neither condition is met, it multiplies the 'pointsearned' value by 1, which means no bonus is applied.

Learn more about proc sql step for giving bonuses to frequent-flyer program members based on travel distance here:

https://brainly.com/question/32709902

#SPJ14