Teste de Microsoft SQL (Nível Avançado)

Q 1. Refer the table schema given below:

CREATE TABLE students 
  ( 
     id        INT NOT NULL, 
     firstname VARCHAR(255) NOT NULL, 
     lastname  VARCHAR(255) NOT NULL, 
     email     VARCHAR(255), 
     address   VARCHAR(255) NOT NULL, 
     country   VARCHAR(255) NOT NULL 
  ); 

CREATE TABLE olympiads 
  ( 
     id        INT NOT NULL, 
     title     VARCHAR(255) NOT NULL, 
     studentid INT NOT NULL, 
     place     INT NOT NULL 
  ); 

You have written below query to get the information about students who are from the country which took first places in Olympiads.

SELECT * 
FROM   students 
XXXX
FROM   students 
                          JOIN olympiads 
                            ON olympiads.studentid = students.id 
                               AND olympiads.place = 1) 

How will you replace XXXX so that the query will produce the required output without any error?

Q 2. You have decided to back-up data from one table (transactions) to another table (newtransactions) in an external database.
The table has the following schema:

CREATE TABLE transactions 
  ( 
     id                    INT, 
     customerid     INT NOT NULL, 
     employeeid    INT NOT NULL, 
     country          VARCHAR(255), 
     sum                INT NOT NULL 
  ); 

You are interested in backing up data about transactions made in the USA and having a SUM over 10000.

Which of the following statements would allow you to make the needed backup?