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 backup 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 USA and having SUM more than 10000.

Which of the following statement will allow you to make the needed backup?