Aberto

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

Habilidades: SQL, MySQL, Administração de Bancos de Dados, Programação de Banco de Dados, PHP

Acerca do Empregador:
( 0 comentários ) Kurukshetra, India

ID do Projeto: #21693416

41 freelancers estão ofertando em média $992 para esse trabalho

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 Mais

$750 USD in 7 dias
(141 Comentários)
6.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 Mais

$833 USD em 1 dia
(66 Comentários)
5.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 Mais

$1125 USD in 7 dias
(53 Comentários)
5.5
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 Mais

$1000 USD in 10 dias
(19 Comentários)
5.6
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, Mais

$1200 USD in 15 dias
(59 Comentários)
5.9
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 Mais

$1125 USD in 7 dias
(13 Comentários)
5.1
XueminJ

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 in 7 dias
(16 Comentários)
4.8
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 Mais

$1125 USD in 7 dias
(13 Comentários)
4.5
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 Mais

$1125 USD in 7 dias
(11 Comentários)
4.3
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 Mais

$833 USD in 3 dias
(15 Comentários)
3.8
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 Mais

$1125 USD in 15 dias
(9 Comentários)
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 dias
(4 Comentários)
2.4
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 Mais

$1125 USD in 7 dias
(4 Comentários)
2.5
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 Mais

$750 USD in 7 dias
(2 Comentários)
2.2
Alexey1124

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 in 7 dias
(3 Comentários)
1.8
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 Mais

$1125 USD in 7 dias
(2 Comentários)
1.5
panther0103

I've little changed. I think I am ready to work with you. Thanks. Here is the sql. SET @players_count:=(SELECT COUNT(*) FROM player); DROP TEMPORARY TABLE IF EXISTS tbl_tmp; CREATE TEMPORARY TABLE tbl_tmp(storeID I Mais

$1000 USD in 7 dias
(2 Comentários)
1.6
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 Mais

$1125 USD in 7 dias
(2 Comentários)
1.8
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 Mais

$888 USD em 1 dia
(1 Comentário)
0.6
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 Mais

$1300 USD em 1 dia
(1 Comentário)
0.4