Creating a SQL request
abuse, missingdata_order secondary tables, complaints from users.
The task
Get a grouped user list (user_id) with the following information:
1) call-to (count) shopping_id (WHERE stage = 'open')
2) call-to (count) shopping_id (WHERE stage = 'shoping')
3) call-to (count) shopping_id (WHERE stage = 'close')
4) call-to (count) order_id (from abuse)
5) call-to (count) id (from missingdata_order)
Client's review of cooperation with freelancer
Creating a SQL requestI recommend as a good specialist.
Freelancer's review of cooperation with Vladislavs Sipov
Creating a SQL requestGood customer, clearly explains the task and always in contact, I will be happy to continue cooperating!
![]()
-
205
Hello to you.
Ready to do.
Experience over 10 years
Programming PHP, MySQL and JavaScript
Correction of any errors
Fire - Any
Connection of Payment
Cleaning from viruses
… Acceleration of loading
High loaded projects
Complexity of any
Best Regards, Genadi!
–
-
502 4 0 Hello to you. Ready to help with your task. It won’t take a lot of time, as there’s experience in writing scripts, only you’ll have a couple of technical questions about your BD.
Good day !
-
259 6 0 Ready to start work! I have great experience in fulfilling such requests!
-
245 4 0 Good day . Ready to fulfill your order! Contact us, I will be happy to collaborate!
-
1712 177 2 2 Good day Vladislav ready to make a request sql I will do everything quickly and quality
Current freelance projects in the category Databases & SQL
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 5 hours 29 minutes back ∙ 3 proposals |
Database synchronizationSynchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 11 hours 21 minutes back ∙ 8 proposals |
Setting up a backup system and optimizing server infrastructureObjective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 1 day 9 hours back ∙ 23 proposals |
PIM system
225 USD
A PIM system needs to be created. The number of products is several million. There are several suppliers providing data in different formats: csv, xml, API. The data is limited, and often it is necessary to find product characteristics from other sources and supplement them. A… Databases & SQL, Web Programming ∙ 1 day 11 hours back ∙ 43 proposals |
Integration of BAS Shveyka 8
225 USD
Good day, it is necessary to integrate BAS Shveyka 8, connect the website and CRM Sales Drive, set up reports and other data. Databases & SQL ∙ 1 day 12 hours back ∙ 10 proposals |