SQL part2
11 USD We have a database:
sales (id, date, product_id, employee_id, number, discount)
products (id, name, price)
employees (id, first_name, last_name, gender, age, salary)
Write SQL queries based on this database that output the following information:
- Employees (first name and last name) and the difference between their total sales in monetary units (according to the price list, without considering the discount) for the entire period and their salary
- A table with sales, which will also include a text field with two possible values - "with discount"/"without discount" depending on whether these sales had a discount or not.
- A list of employees (first name and last name in one field) and the status "young"/'not very young" depending on whether the employee is 45 years old or not.
Applications 3
Client's review of cooperation with Andrii Panichuk
SQL part2The freelancer approached the task professionally, completed everything quickly and efficiently. The collaboration went excellently, I recommend!
Freelancer's review of cooperation with Yevhen Inchevsky
SQL part2Thank you for the project, I will be happy to continue working with you.
-
1 day11 USD
338 2 0 1 day11 USD
Good evening, I am ready to help you with your issue. I have experience working with databases. Write to me, we will discuss the details.
-
1 day11 USD
2052 226 0 1 1 day11 USD
Hello! I have completed such tasks more than once, possibly even these, I will gladly do it again.
-
1 day11 USD
543 2 0 1 day11 USD
In the IT field for 8+ years - I will write queries for you. Please clarify which Database you have?
-
1 day11 USD
1218 21 0 1 day11 USD
I will do it now......................................................................
-
1 day11 USD
654 10 0 1 day11 USD
Good evening! I can also perform, just like all the other tasks (SQL, Excel, Power BI)
-
1 day11 USD
931 112 0 1 day11 USD
Good day, I am ready to write requests.
Feel free to reach out, I will be happy to collaborate.
Current freelance projects in the category Databases & SQL
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 1 day 15 hours back ∙ 6 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 2 days 6 hours back ∙ 8 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 7 days 5 hours back ∙ 12 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 7 days 16 hours back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 10 days 23 hours back ∙ 17 proposals |
Odessa