Click here to Skip to main content
15,918,258 members
Home / Discussions / Database
   

Database

 
QuestionSimplest SQL for Mac? Pin
Member 107310637-Apr-14 7:06
Member 107310637-Apr-14 7:06 
AnswerRe: Simplest SQL for Mac? Pin
Jörgen Andersson7-Apr-14 8:33
professionalJörgen Andersson7-Apr-14 8:33 
GeneralRe: Simplest SQL for Mac? Pin
Member 107310637-Apr-14 9:08
Member 107310637-Apr-14 9:08 
QuestionMango database Pin
Member 99929934-Apr-14 10:50
Member 99929934-Apr-14 10:50 
AnswerRe: Mango database Pin
Richard Andrew x645-Apr-14 10:53
professionalRichard Andrew x645-Apr-14 10:53 
GeneralRe: Mango database Pin
Member 99929935-Apr-14 20:11
Member 99929935-Apr-14 20:11 
AnswerRe: Mango database Pin
Chris Quinn7-Apr-14 0:12
Chris Quinn7-Apr-14 0:12 
QuestionDB Mango Pin
Member 99929934-Apr-14 10:50
Member 99929934-Apr-14 10:50 
Hello please i would ask you if you can help me there, thank you in advance

CSS
if we have two dataset 1-First dataset contains population data of cities in the United States of America. Each record in the dataset has the following format:
{
     "city": "ACMAR",
     "loc": [
         -86.51557,
         33.584132
     ],
     "pop": 6055,
     "state": "AL",
     "_id": "35004"
}

Second dataset contains log data from a geo-locational service. Each record in the dataset has the following format:
{
    "_id": {
        "$oid": "5191f53b1b76a5666a8cbd64"
    },
    "status": 200,
    "requrest_time": 504,   // in milliseconds
    "type": "stationboard",
    "datetime": {
        "$date": "2014-02-19T07:03:32.000Z"
    }
}

1-how we can Get all the states that have at least 2 cities with population > 1000000 (1M).and we need to  Remember that city can be splitted into multiple records, and we should aggregate its population first. (zips dataset)

2- we need Find a day (date) with the largest number of HTTP 500 errors (status=500).

AnswerRe: DB Mango Pin
Mycroft Holmes4-Apr-14 14:12
professionalMycroft Holmes4-Apr-14 14:12 
GeneralRe: DB Mango Pin
Jörgen Andersson4-Apr-14 23:53
professionalJörgen Andersson4-Apr-14 23:53 
AnswerRe: DB Mango Pin
Simon_Whale7-Apr-14 1:17
Simon_Whale7-Apr-14 1:17 
QuestionDowngrade Sql server database Pin
dilkonika4-Apr-14 9:07
dilkonika4-Apr-14 9:07 
AnswerRe: Downgrade Sql server database Pin
Mycroft Holmes4-Apr-14 14:16
professionalMycroft Holmes4-Apr-14 14:16 
AnswerRe: Downgrade Sql server database Pin
Andrius Leonavicius4-Apr-14 14:27
professionalAndrius Leonavicius4-Apr-14 14:27 
QuestionSearch in textbox Pin
Member 107240203-Apr-14 23:09
Member 107240203-Apr-14 23:09 
AnswerRe: Search in textbox Pin
Richard Deeming4-Apr-14 0:59
mveRichard Deeming4-Apr-14 0:59 
QuestionHow to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE Pin
Ravi900kumar3-Apr-14 10:28
Ravi900kumar3-Apr-14 10:28 
GeneralRe: How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE Pin
PIEBALDconsult3-Apr-14 10:41
mvePIEBALDconsult3-Apr-14 10:41 
QuestionDB Mango Pin
Member 99929933-Apr-14 9:43
Member 99929933-Apr-14 9:43 
AnswerRe: DB Mango Pin
Mycroft Holmes3-Apr-14 12:59
professionalMycroft Holmes3-Apr-14 12:59 
Questionselecting data from two tables Pin
Member 102635192-Apr-14 3:05
Member 102635192-Apr-14 3:05 
AnswerRe: selecting data from two tables Pin
Richard Deeming2-Apr-14 3:24
mveRichard Deeming2-Apr-14 3:24 
GeneralRe: selecting data from two tables Pin
Member 102635192-Apr-14 19:28
Member 102635192-Apr-14 19:28 
GeneralRe: selecting data from two tables Pin
Richard Deeming3-Apr-14 1:03
mveRichard Deeming3-Apr-14 1:03 
AnswerRe: selecting data from two tables Pin
Jörgen Andersson2-Apr-14 3:25
professionalJörgen Andersson2-Apr-14 3:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.