SQL Queries
11 USD I have a database with the following tables:
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:
- All product names.
- All fields from the employees table, but only output the first three rows.
- All sales for May 5, 2024.
- The average price of those products whose id is greater than 10.
- The date and quantity from the sales table + the name from the products table.
The corresponding tables are provided in the appendix.
Applications 3
Client's review of cooperation with Andrii Panichuk
SQL QueriesI am very satisfied with the collaboration!
The task was completed quickly and professionally.
Andriy approached the work responsibly. I recommend!
Freelancer's review of cooperation with Yevhen Inchevsky
SQL QueriesThank you for your cooperation!
I recommend!
-
1 day11 USD
543 2 0 1 day11 USD
Good day.
I will write you the requests, just clarify which specific database.
-
1 day11 USD
2049 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
338 2 0 1 day11 USD
Hello.
I will make queries for the database, working until the project is fully approved.
I suggest creating a test version. If it works for you - we will make a Safe. This way you will see partial results of the work before payment.
Write to me, we will discuss the details.
-
1 day11 USD
1218 21 0 1 day11 USD
I will do it now......................................................................
-
1 day11 USD
931 112 0 1 day11 USD
Good day, I am knowledgeable on this topic, ready to help.
Feel free to reach out, I will be happy to collaborate.
-
1 day11 USD
1321 62 2 1 1 day11 USD
Good day.
I can write queries in MySQL or MSSQL or Postgres...
-
1 day11 USD
575 17 0 1 day11 USD
Good day!
I am ready to perform now.
May I request a database dump?
-
1 day11 USD
654 10 0 1 day11 USD
Good evening! I can create queries in POSTRE SQL or Microsoft SQL. We can discuss in detail in private messages.
-
ех, студенти-студенти, вчитись треба))
-
Current freelance projects in the category Databases & SQL
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 3 hours 6 minutes back ∙ 16 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 20 hours 25 minutes back ∙ 8 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 1 day 13 hours back ∙ 81 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 1 day 17 hours back ∙ 13 proposals |
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 ∙ 3 days 15 hours back ∙ 6 proposals |
Odessa