Simple SQL queries

Fermé

Description

Simple Microsoft SQL queries on two database tables:

1. To show how many unique tests are run, how many times they were run by each user with an ‘a’ affiliation before a particular date and order the result starting from the user running the largest number of unique tests.

2. Adjust query 1 to show all ‘a’ users, whether or not they ran any tests.

3. To show on each day that tests were run both how many unique tests were run and the total number of times these tests were run. Break the results down by affiliation and order the results starting with the oldest date on which tests were run.

Compétences : Serveur SQL Microsoft

Voir plus : sharepoint form queries sql, sql simple work, important queries sql server, queries sql 10g, oracle sql simple assignment, building search queries sql, virtuemart queries sql, tree queries sql, sql simple connection string asp, pl sql simple cursor, metatrader sql simple, iphone sql simple, php sql simple post mysql, access database sql simple project, wordpress sql custom query category, sql 2000 query running totals, vbscript query users organization, sql search query filter, sharepoint sql report query caml, sql customers query, sql tree query, sql snmp query, sql server query rijndael aes net, creloaded sql search query, sql tree query child

N° du projet : #13466550

Décerné à :

jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Plus

35 $ USD en 1 jour
(13 Commentaires)
4.1

9 freelance ont fait une offre moyenne de 31 $ pour ce travail

msalahii

Hello, My Name is Muhammad Salah and I'm Microsoft Certified Database Administrator and I will do your project and finish in few hours just text me on chat. Thanks

30 $ USD en 0 jours
(3 Commentaires)
3.1
harshitkag2010

i am 3rd year computer science engineering student and have done projects using mysql so have enough knowledge to work on it.

15 $ USD en 1 jour
(0 Commentaires)
0.0
35 $ USD en 1 jour
(0 Commentaires)
0.0
Odelaney

A proposal has not yet been provided

30 $ USD en 1 jour
(0 Commentaires)
0.0
25 $ USD en 1 jour
(0 Commentaires)
0.0
sharma0481

Hi. I have 10+ year experience and my skill are: Software, Android ,Web Developer & Designer (VB-C# Dot net, Android Studio, Visual Foxpro, CodeIgniter, Core php, HTML5, Responsive, Bootstrap) You can check my fe Plus

30 $ USD en 1 jour
(0 Commentaires)
0.0
20 $ USD en 2 jours
(0 Commentaires)
0.0
Meagan26

Hello, I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. i have recently also earned my preferre Plus

55 $ USD en 1 jour
(0 Commentaires)
0.0