Bilgi Teknolojisi Ödev Yardımı
Bilgi teknolojisi atama yardımı, kullanıcılara en ileri bilim ve teknoloji hakkında çok yüksek kalitede bilgi sağlayabilir. Çok detaylı kategorize edilmiş bilgi verileri vardır ve yazılımın kendisinin bunları kullanma izni yoktur, böylece herkes teknolojiden sonuna kadar yararlanabilir.
Alışılmışın dışında teknoloji ve yaşam için de mükemmel bir içerik organizasyonudur. İlginç ve profesyonel içerik üretmek için kullanıcıları ve markaları birbirine bağlar. Teknik bilgiler, derinlemesine incelemeler, beceri ipuçları ve ürün deneyimleri vb. içerir. Grafik, video ve bilgilendirici reklam içerik formatlarına sahiptir ve başlıca yeni medya platformlarını kapsar.
- Uples to answer the following questions by SQL commands. employee (ssn fname address, city,dob, salary,job code) (job code, job position) a) Concatenate and display the first name and last name of all employees. List them in a descending order according to their salary. (4 points) SELECT CONCAT _WS(", "fname', "Iname') AS FullName FROM employee ORDER BY FullName DESC; b) List all employees first name and last name who was born between 2000 and 2005 (4 points) SELECT fname , Iname FROM employee WHERE BORN BETWEEN 2000 AND 2005; c) List the SSN and salary of all employees who carn more than 5000 Change the column name of salary to MANAGERS. (4 points) SELECT SSN , salary AS MANAGERS FROM employee WHERE MANAGERS >5000; d) Find the total amount of salary each employee will earn at the end of 1 year (4 points) e) List the number of employees in each job. Display those which has less than 3 in the group.(7 points)
- Q1-Asswer the following questions by writing an SOL statement using the tables below. (21 points) , frame, dob, dop,addren, city) book (isny, title, no of pages, publisher writer) reservationirsectration M, date out, date a) Display finst name lant name and address of all guests whose city is same as Alex Ball (7 points) SELECT fname , Iname , address FR OM guest WHERE city='Alex Bald' b) Display the guests fname, Iname and the name of the book they took out. (7 points) c) Display the number of books each guest tock out in lotal (7 points)
- 8. Create a table named "Students" with the following columns: StudentID (integer) FirstName (varchar.maximum length 50) LastName (varchar maximum length 50) BirthDate (date) Major (varchar maximum length 100) 9. Insert two sample rows into the "Students" table with diverse information. fort Name last Nam 10. Write a query to add a new column named "Nationality" with a data type of VARCHAR (20) to the "Students "table.
- 9. Insert two sample rows into the "Students" table with diverse information.
- Identify the SELECT statements that execute successfully. SELECT first name, last name job id , salary12 AS "Yearly Sal" FROM employees; SELECT first name, last name ,job __ id, salary12 yearly sal FROM employees; SELECT first name, , last name,job id, salary AS yearly sal FROM employees; SELECT first n ame+last name AS name,job __ Id, salary*12 yearly sal FROM employees;