client_calls.sql

# The client user execution script for Project Three - CNT 4714 - Spring 2020
# all commands assumed to be executed by the client user
# the client user has only selection  privilege on the project3 database schema
#
#Command 1:
#   Query: Which rider won the World Championship - Elite Women in 2015?
select ridername
from racewinners
where racename = 'World Championship - Elite Women' and raceyear = 2019;

#Commands 2A, 2B, and 2C:
#   Delete all the riders from Norway from the riders table.
#   * * * Do a "before" and "after" select * from riders for this command.
#   Note: the before and after select statements will execute, but the delete will not
#         thus no changes will be reflected in the before and after snapshots.
select * from riders;
delete from riders where nationality = 'Norway';
select * from riders;

#Commands 3A, 3B, and 3C:
#    Update rider Mark Renshaw to show number of wins = 40 in the riders table.
# * * Do a "before" and "after" selection on the riders table
#   Note: the before and after select statements will execute, but the delete will not
#         thus no changes will be reflected in the before and after snapshots.
select * from riders;
update riders set num_pro_wins = 245 where ridername = "Marianne Vos";
select * from riders;