Project translated automatically. Log in or register, to view the original 1 .Choose orders in which the sum order does not match the deposit amount.The 2ndFor each employee, choose the percentage of the salary of the department.3 .Choose the average amount for which the buyer 'JUST BIKES' makes an order each year.and 4.To determine whether the cases when the products were sold were not recorded at the moment at the sale.The name of the product, the date of sale, the buyer.and 5.Find out in which states they buy the most expensive product.6 .Choose the name and city for the departments in which the salary discount of employees is less than 2000 (not taking into account the departments consisting of one employee).use the SELECT operator and its main sections to select data according to the specified conditions.To demonstrate the process of database design to start using SQL-commands to create tables and manage limitations – to learn to create and use representations when selecting data; to learn to create and trigger user-saved procedures, and to transmit parameters in them; to learn how to create triggers.

Applications6

ZIP

Додаток Мови SQL-запит__в Лабораторна робота 1L1.zip

9KB

ZIP

Додаток Мови SQL-запит__в Лабораторна робота 2 L2.zip

71KB

DOC

Методичка Мови SQL-запит__в Лабораторна робота 3.doc

67KB

DOC

Методичка Мови SQL-запит__в Лабораторна робота 2.doc

98KB

DOC

Методичка Мови SQL-запит__в Лабораторна робота 1.doc

110KB

DOC

Методичка Мови SQL-запит__в Контрольна робота.doc

72KB

Proposals 2 Withdrawn 1 Rejected 3 Discussions 6

Eugene Walby

Winning proposal

10 0

Projects 5
Rating -
Rating 229

Budget: 250 UAH Deadline: 3 days

Ready to perform. My email is [email protected].

Nikolay Khablenko

28 0

Projects 25
Rating -
Rating 517

Budget: 50 USD Deadline: 5 days

Good day, I am ready to help you with your task.
So I understand, you need to describe how to make requests and explain what is done?
Ready to help write.
Ready to begin to discuss the detailed TZ, deadlines and prices.
Phone(s): +380988947376, +380669499828
Email: [email protected]

Key information

Languages: C#, SQL (3+ years), Delphi (7+ years), C++ (7+ years).
Technologies: WPF; WCF; ADO.NET; LINQ;
• Databases: MS SQL Server (design, stored procedures, etc.))
Version Control: Subversion (TortoiseSVN)
• Additional: Java, HTML, CSS

Education
Kharkiv Aerospace University “HAI” (Kharkov, Ukraine)
System Programming, Computer Engineering Specialist

Maintenance of Languages

English - Medium
Russian is free
Ukrainian - native