$AQ1.$ How does creating a query to connect to the data allow quicker and more efficient access and analysis of the data than connecting to entire tables?

AQ$1$a$.$ Based on the video, when writing the SQL $($standard query language$),$ what is usually going to be the first word you use in any of the queries? What is it indicating?

AQ$1$b$.$ What does the $*$ indicate after the TRANSACT table?

AQ$1$c$.$ Which table are we pulling the attribute STATE from?

AQ$1$d$.$ Which attribute is creating the primary key$/$ foreign key relationship between the tables TRANSACT and STORE?