Closed

Project of Sql Queries

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

Thanks

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

Thanks

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

About the Employer:
( 0 reviews ) Kurukshetra, India

Project ID: #21693416

40 freelancers are bidding on average $1005 for this job

royalwebraisers

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
(149 Reviews)
6.7
amiitkumar19

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
(56 Reviews)
5.6
marasinghe82

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
(66 Reviews)
5.7
SergioAlfaroV

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
(20 Reviews)
5.6
FutureTechno1

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)
5.2
mdubey

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
(61 Reviews)
6.0
zeeshan411

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
(23 Reviews)
4.6
jayantavkumar

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
(15 Reviews)
4.6
tausy

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)
4.4
sujae815

SQL Expert is here!@ I have read your requirements and i am really interested in your project. I have rich experience in this field and i can implement your requirements perfectly. If you hire me, you will get gold res More

$1125 USD in 7 days
(4 Reviews)
3.7
TEKSCENT

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
(3 Reviews)
3.4
AkashW

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)
3.3
NoSonforhim

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

$750 USD in 7 days
(4 Reviews)
2.4
Yura615

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)
2.2
athminteam

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)
2.5
aap31374

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
(2 Reviews)
1.2
zorioninfotech

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)
1.8
gharamti

⭐⭐⭐⭐⭐ 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
(1 Review)
0.4
WebDeveloperAV

Hello client, I am having good knowledge of complete web development and SQL is my strongest zone, you can DM for the query. Regards, Aman Saini

$999 USD in 1 day
(0 Reviews)
0.0
WeResolveIt

Hello, I'm certain I can exceed your expectations. I've been working with SQL for over 8 years now and I'd class myself as an expert. I'll write your SQL queries with 100% accuracy, fully optimised with necessary com More

$750 USD in 7 days
(0 Reviews)
0.0