פתרונות SQL Server

הפתרונות הבאים תקפים לפלטפורמת מיקרוסופט, לפתרונות עבור פלטפורמת אורקל לחץ כאן.

-- 1
SELECT * FROM customers
-- 2
-- Error, From clause must follow Select Clause
-- 3
SELECT pack_id , speed, monthly_payment AS 'MP'FROM packages
-- 4
-- Query executed successfully : SELECT strt_date , monthly_paymentFROM packages
-- 5
-- Error, comma cannot follow last column on the SELECT listSeleCT last_NAME , fiRST_NamE , FROM customers
-- 6
SELECT customer_id, first_name , last_name , main_phone_num , 
secondary_phone_num , pack_id
FROM customers
-- 7
SELECT first_name , last_name , join_date , monthly_discount , 
monthly_discount * 1.2 AS 'DC_N' , monthly_discount * 0.6 AS 'DC_L' 
FROM customers
-- 8
SELECT pack_id , speed, strt_date, monthly_payment, 
monthly_payment * 12 AS 'Y_INCOME'
FROM packages
-- 9
-- E
-- 10
SELECT first_name + ' ' + last_name AS 'FULL_NAME' ,
main_phone_num + ' / ' + secondary_phone_num AS 'CONTACT_DETAILS'
FROM customers
-- 11
SELECT DISTINCT city FROM customers
-- 12
SELECT DISTINCT state FROM customers
-- 13
SELECT DISTINCT state, city FROM customers
-- 14
SELECT last_name + ' ' + state AS 'EMPLOYEE_AND_STATE' FROM customers
-- 15
SELECT first_name AS 'FN' ,last_name AS 'LN' ,
monthly_discount AS 'DC' ,city + ' ' + state + ' ' + street AS 'FULL_ADDRESS'
FROM customers
-- 16
SELECT DISTINCT monthly_discount FROM customers
-- 17
SELECT DISTINCT pack_id FROM customers

פתרונות Oracle

-- 1
SELECT * FROM customers
-- 2
-- Error, From clause must follow Select Clause
-- 3
SELECT pack_id , speed, monthly_payment AS "MP" FROM packages
-- 4
-- Query executed successfully : SELECT strt_date , monthly_paymentFROM packages
-- 5
-- Error, comma cannot follow last column on the SELECT listSeleCT last_NAME , fiRST_NamE , FROM customers
-- 6
SELECT customer_id, first_name , last_name , main_phone_num , 
secondary_phone_num , pack_id
FROM customers
-- 7
SELECT first_name , last_name , join_date , monthly_discount , 
monthly_discount * 1.2 AS "DC_N" , monthly_discount * 0.6 AS "DC_L"
FROM customers
-- 8
SELECT pack_id , speed, strt_date, monthly_payment, 
monthly_payment * 12 AS "Y_INCOME"
FROM packages
-- 9
-- ה - אף תשובה איננה נכונה
-- 10
SELECT first_name || ' ' || last_name AS "FULL_NAME",
main_phone_num || ' / ' || secondary_phone_num AS "CONTACT_DETAILS"
FROM customers
-- 11
SELECT DISTINCT city FROM customers
-- 12
SELECT DISTINCT state FROM customers
-- 13
SELECT DISTINCT state, city FROM customers
-- 14
SELECT last_name || ' ' || state AS "EMPLOYEE_AND_STATE" FROM customers
-- 15
SELECT first_name AS "FN" ,last_name AS "LN" ,
monthly_discount AS "DC" ,city || ' ' || state || ' ' || street AS "FULL_ADDRESS"
FROM customers
-- 16
SELECT DISTINCT monthly_discount FROM customers
-- 17
SELECT DISTINCT pack_id FROM customers