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


Habilidades: SQL, MySQL, Administración de bases de datos, Programación de bases de datos, PHP

Información del empleador:
( 0 comentarios ) Kurukshetra, India

Nº del proyecto: #21693416

42 freelancers están ofertando el promedio de $1002 para este trabajo


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 Más

$750 USD en 7 días
(142 comentarios)

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 Más

$833 USD en 1 día
(66 comentarios)

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 Más

$1125 USD en 7 días
(54 comentarios)

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 Más

$1000 USD en 10 días
(19 comentarios)

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 Más

$1125 USD en 7 días
(13 comentarios)

Hi. I am very interesting in your job. I am sql expert. I have developed many sites using mysql. I can do it perfectly. Let's discuss about project in detail via chat. Thanks regards

$1125 USD en 7 días
(17 comentarios)

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, Más

$1200 USD en 15 días
(59 comentarios)

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 Más

$1125 USD en 7 días
(13 comentarios)

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 Más

$1125 USD en 7 días
(11 comentarios)

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 Más

$833 USD en 3 días
(15 comentarios)

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 Más

$1125 USD en 15 días
(9 comentarios)

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 en 7 días
(4 comentarios)

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 Más

$750 USD en 7 días
(2 comentarios)

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 Más

$1125 USD en 7 días
(4 comentarios)

ok. I can do it. Can I see the database? If I can see the tables of database, I can do it perfectly. Thank you.

$750 USD en 7 días
(3 comentarios)

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 Más

$1125 USD en 7 días
(2 comentarios)

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 Más

$1125 USD en 7 días
(2 comentarios)

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 Más

$888 USD en 1 día
(1 comentario)

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 Más

$1300 USD en 1 día
(1 comentario)

Thanks for posting this project. Introducing myself, I am a software engineer and currently designated as a team leader. I have got 8 years of experience in the software field. I have an excellent knowledge in ORACLE Más

$750 USD en 5 días
(0 comentarios)