FIND basics - Revision history

Andr3w at 15:24, 12 November 2015

2015-11-12T15:24:10Z

← Older revision		Revision as of 15:24, 12 November 2015
Line 112:		Line 112:

	<div class=q data-lang="py3">		<div class=q data-lang="py3">
	<p class=strong>Show capital and population for the top 5 ~~capital cities~~ starting with the letter "M" that have a population of less than 3 million </p>		<p class=strong>Show capital and population for the top 5 countries (by population) starting with the letter "M" that have a population of less than 3 million </p>
	<pre class=def>		<pre class=def>
	</pre>		</pre>

2015-11-06T10:09:21Z

← Older revision		Revision as of 10:09, 6 November 2015
Line 92:		Line 92:

	<div class=q data-lang="py3">		<div class=q data-lang="py3">
	<p class=strong>Which country out of China, Russia, and the United States has the largest population</p>		<p class=strong>Which country out of China, Russia, and the United States has the largest population.</p>
			You might want to use [[Sort]] and limit to get the answer.
	<pre class=def>		<pre class=def>
	</pre>		</pre>

2015-11-05T00:52:52Z

← Older revision		Revision as of 00:52, 5 November 2015
Line 44:		Line 44:

	<div class=q data-lang="py3">		<div class=q data-lang="py3">
	<p class=strong>~~How many~~ countries ~~are there~~ in Europe that start with the letter "S"</p>		<p class=strong>List the countries in Europe that start with the letter "S"</p>
	<pre class=def>		<pre class=def>
	</pre>		</pre>
	<div class=ans>		<div class=ans>
	~~print~~(db.world.~~count~~({"~~$and~~":[{"continent":"Europe"},{"name":{"~~$regex~~":~~"^S"}}]~~}))		pp.pprint(list(
			db.world.find({"name":{'$regex':"^S"},
			"continent":"Europe"},{"name":1, "_id":0})
			))
	</div>		</div>
	</div>		</div>

2015-07-30T15:43:14Z

← Older revision		Revision as of 15:43, 30 July 2015
Line 119:		Line 119:
	<p class=strong>Show all the capitals for countries that start with the same letter as their continent</p>		<p class=strong>Show all the capitals for countries that start with the same letter as their continent</p>
	<div class=hint title="Using $where with find" >		<div class=hint title="Using $where with find" >
	find({"$where": " boolean ~~statement~~ "})		find({"$where": " boolean expression "})
	</div>		</div>
	<pre class=def>		<pre class=def>

2015-07-30T15:42:01Z

← Older revision		Revision as of 15:42, 30 July 2015
Line 118:		Line 118:
	<div class=q data-lang="py3">		<div class=q data-lang="py3">
	<p class=strong>Show all the capitals for countries that start with the same letter as their continent</p>		<p class=strong>Show all the capitals for countries that start with the same letter as their continent</p>
			<div class=hint title="Using $where with find" >
			find({"$where": " boolean statement "})
			</div>
	<pre class=def>		<pre class=def>
	</pre>		</pre>

2015-07-30T15:34:51Z

← Older revision		Revision as of 15:34, 30 July 2015
Line 117:		Line 117:

	<div class=q data-lang="py3">		<div class=q data-lang="py3">
	<p class=strong>Show all the capitals for countries that start with the same letter as ~~the~~ continent</p>		<p class=strong>Show all the capitals for countries that start with the same letter as their continent</p>
	<pre class=def>		<pre class=def>
	</pre>		</pre>

2015-07-30T15:34:06Z

← Older revision		Revision as of 15:34, 30 July 2015
Line 119:		Line 119:
	<p class=strong>Show all the capitals for countries that start with the same letter as the continent</p>		<p class=strong>Show all the capitals for countries that start with the same letter as the continent</p>
	<pre class=def>		<pre class=def>
			</pre>
			<div class=ans>
	pp.pprint(list(		pp.pprint(list(
	db.world.find(		db.world.find(
	{"$where":" this.name~~.indexOf(~~this.continent[0]~~) == 0~~"},		{"$where":"this.name[0]==this.continent[0]"},
	{"_id":0, "capital":1})		{"_id":0, "capital":1})
	))		))
	~~</pre>~~
	~~<div class=ans>~~

	</div>		</div>
	</div>		</div>

2015-07-30T15:31:00Z

@@ Line 113: / Line 113: @@
 <div class=ans>
 pp.pprint(list(db.world.find({"$and":[{"capital":{"$regex":"^M"}},{"population":{"$lt":3000000}}]}, {"_id":0, "capital":1, "population":1}).sort("population",-1).limit(5)))
 </div>
 </div>

2015-07-28T21:58:56Z

← Older revision		Revision as of 21:58, 28 July 2015
Line 44:		Line 44:

	<div class=q data-lang="py3">		<div class=q data-lang="py3">
	<p class=strong>How many countries are there in Europe that start with the letter "L"</p>		<p class=strong>How many countries are there in Europe that start with the letter "S"</p>
	<pre class=def>		<pre class=def>
	</pre>		</pre>

2015-07-28T13:16:04Z

← Older revision		Revision as of 13:16, 28 July 2015
Line 89:		Line 89:

	<div class=q data-lang="py3">		<div class=q data-lang="py3">
	<p class=strong>Which country out of [China, Russia, United States] has the largest population</p>		<p class=strong>Which country out of China, Russia, and the United States has the largest population</p>
	<pre class=def>		<pre class=def>
	</pre>		</pre>