Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Updating selected rows

Agents

Report a typo

Here you can see the table agents with important data about key agents of the International Security Agency:

code_number

current_location

citizenship

knows_languages

missions

008

Mexico

UK

4

20

IJ655

London

China

3

7

IL7T

Sevilla

UK

2

5

006

Brest

France

2

50

BV11

Montevideo

Argentina

8

8

A while ago, all experienced agents (those who have completed over 10 missions and know more than 3 languages) had been told to move to Istanbul. They have successfully completed the mission. Now, update the table for these agents by changing their location and the count of successfully completed missions.

Write an SQL statement





___

Create a free account to access the full topic