Project of Sql Queries

I need someone who can write query, if you SQL then only bid , please don't waste time


before you need to pass the following simple test

Write a query to produce a report for each store including stores without any sales. Your result-set should

include the following information:

• the storeID

• the store name

• the number of players that have purchased a badge from the store

• the number of players that have not purchased a badge from the store;

• the total money spent at the store

• the most expensive badge a player has purchased at the store

• the cheapest badge a player has purchased at the store

• the average price of the items that have been purchased at the store.

Send me the correct query i will hire you


Skills: SQL, MySQL, Database Administration, Database Programming, PHP

About the Employer:
( 0 reviews ) Kurukshetra, India

Project ID: #21693416

37 freelancers are bidding on average $1005 for this job


Hi, I can help you in project. Please let me know when we can discuss in more details so that we could proceed further. I do work on following skillsets: php, mysql, codeigniter, laravel, wordpress, jquery, google m More

$750 USD in 7 days
(154 Reviews)

Hello, I have read your job and i’m presenting my proposal for your consideration as a professional website developer and i have great command over HTML5,CSS,CMS and i have already built many responsive websites .My a More

$1125 USD in 7 days
(67 Reviews)

Dear Sir, I'm expert BI developer on MS SQL Server (SSIS SSRS SSAS AND POWERBI) with 14 years of experience . could you please let me know the details what you required. I can give you best solution for you to. Comple More

$833 USD in 1 day
(67 Reviews)

Hello! I am a Computer Engineer, with a Master of Business Administration and an MCSA SQL Server 2014, with 12 years of experience using SQL, queries, reports/dashboards design and construction, database management, da More

$1000 USD in 10 days
(22 Reviews)

Hi, I have an expert team of developers for web, mobile, blockchain, Designer, Tester, etc. For 5+ years I’ve worked in Development and so I am accustomed to working with all sorts of products and services, and in a v More

$1125 USD in 7 days
(13 Reviews)

Respected Client, I have 6 years of exp of working with database MySQL and MSSQL, ORACLE [login to view URL] me via chat box so that we can discuss all the details of project with you in brief along with milestone deliverable, More

$1200 USD in 15 days
(63 Reviews)

Hi, I have read your project description. I am full stack developer having 10 years working experience and I am very confident to build your website in PHP, WordPress, Laravel, Codignator and Reactjs. I am an exp More

$833 USD in 3 days
(32 Reviews)

Proposal - I will prepare a query and will show either in skype or some other way. But cannot share to you until and unless you will not assign the project. There are many employer who needs only one query to be develo More

$1125 USD in 7 days
(22 Reviews)

Hi, I'm a data engineer with over 5 years of experience working on databases, data warehouses, big data systems, machine learning and AI systems. I worked on various databases such as MySQL, Oracle, SQL Server, Netezz More

$1125 USD in 7 days
(12 Reviews)

PF the query: Select [login to view URL], [login to view URL] , [login to view URL], [login to view URL], [login to view URL], purchase.max_cost, purchase.min_cost, purchase.avg_cost from store s More

$1300 USD in 1 day
(4 Reviews)

Hi, Greeting of the day, We can fulfill all your needs regarding the web and mobile application development projects. We have a team of expert developers and designers which can work on your project as per your list More

$1125 USD in 15 days
(9 Reviews)

I have 20 years in Database Developing, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6,, and MS SQL server

$750 USD in 7 days
(4 Reviews)

Hello sir. Thank you for giving me a chance to bid on your project I have gone through your requirements. I have much experience in this field. I am sure that I can finish your project as you want. So please come up o More

$750 USD in 7 days
(2 Reviews)

Hi, This is Vipin. I have 6+ years of experience in web development and has expertise in Python, PHP, HTML, Angular and Ionic framework. I have gone through your project description and would like to work on your pro More

$1125 USD in 7 days
(4 Reviews)

Attached is query. I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and perfor More

$888 USD in 1 day
(4 Reviews)

⭐⭐⭐⭐⭐ Dear Sir, I am professional Web designer & developer with high experience. I have unique combination of both skills which helps me combine between pixel perfection and code efficiency. After reviewing your propos More

$750 USD in 3 days
(2 Reviews)

hi dear sir/mam after reviewing your job requirement carefully We Are100% sure that i can help u to achieve your goal in your time frame with over all 5+year hand of experience in java,php,android,laravel,bootstrap,cod More

$1125 USD in 7 days
(2 Reviews)

Please provide your email address so that I can send you the query.

$1333 USD in 3 days
(0 Reviews)

We have a team expert in Web Designing, Application Development and Databases. We have worked on various projects across various industry verticals. We are specialized in IT Projects and have a team to handle various a More

$1500 USD in 60 days
(0 Reviews)

Hello, I have over 5 years of experience as a data engineer so I think I would be perfect for this job. I can start today/tomorrow so don't hesitate to contact me. The query you requested (of course this could be ex More

$1000 USD in 2 days
(0 Reviews)