Petar

Task 1 Query a count of the number of cities in CITY having a Population larger than 100.000. The CITY table is described as follows: Field Type ID NUMBER

The Task Write a query to print all prime numbers less than or equal to 1000. Print your result on

The Task You are given a table, Projects, containing three columns: Task_ID, Start_Date and End_Date. It is guaranteed that the difference between the End_Date and the Start_Date is equal

The Task You are given two tables: Students and Grades. Students contain three columns: ID, Name, and Marks. Column Type ID Integer Name String

The Task Julia just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query

The Task Our conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy:   Given the

“Higher Then” Queries Query the Name of any student in STUDENTS who scored higher than  Marks. Order your output by the last three characters of each name.

Two results set queries Generate the following two result sets: Note: There will be at least two entries in the table

Query the list of # starting with vowels Query the list of CITY names beginning with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain

Let’s jump to the first task! Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for