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
572 2 0 1 day11 USD
Good day.
I will write you the requests, just clarify which specific database.
-
1 day11 USD
2125 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
954 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
1351 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
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 16 hours 54 minutes back ∙ 3 proposals |
Excel Specialist / Process Automation (Excel + preferably programming)We are looking for a specialist with ADVANCED knowledge of Excel to optimize the existing file and automate processes. It will be a great advantage if you also have programming skills / VBA / Power Query / Power Automate or experience in creating complex logic in Excel. Project… Python, Databases & SQL ∙ 18 hours 46 minutes back ∙ 32 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 19 hours 52 minutes back ∙ 16 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 2 days 11 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 3 days 16 hours back ∙ 35 proposals |
Odessa