<commit_before># MongoDB - Aula 03 - Exercício
autor: <NAME>

## 1. Liste todos Pokemons com a altura menor que 1.5
	
	```
	var query = {height: {$lt 1.5}}
	var campos = {name: 1,height: 1}
	db.pokemons.find(query,campos)
	{ "_id" : ObjectId("5647233fddd3df0aacc81f79"), "name" : "luxray", "height" : 1.4 }
	{ "_id" : ObjectId("5643f5ac8a3351185ddd5461"), "name" : "Pikachu", "height" : 0.4 }
	{ "_id" : ObjectId("5643f6e88a3351185ddd5462"), "name" : "bulbassauro", "height" : 0.5 }
	```
	
## 2. Liste todos Pokemons com a altura maior ou igual que 1.5;
	
	```
	var query = {height: {$gte: 1.5}}
	db.pokemons.find(query,campos)
	{ "_id" : ObjectId("5647233fddd3df0aacc81f78"), "name" : "heatran", "height" : 1.7 }
	{ "_id" : ObjectId("5647233fddd3df0aacc81f7a"), "name" : "bouffalant", "height" : 1.6 }
	{ "_id" : ObjectId("5647233fddd3df0aacc81f7b"), "name" : "Mega mewtwo Y", "height" : 1.5 }
	{ "_id" : ObjectId("5647233fddd3df0aacc81f7c"), "name" : "Armaldo", "height" : 1.5 }<commit_msg><NAME> de Araujo - MongoDB - Exercício 03 - resolvido<commit_after># MongoDB - Aula 03 - Exercício
autor: <NAME>

## 1. Liste todos Pokemons com a altura menor que 1.5
	
	```
	var query = {height: {$lt 1.5}}
	var campos = {name: 1,height: 1}
	db.pokemons.find(query,campos)
	{ "_id" : ObjectId("5647233fddd3df0aacc81f79"), "name" : "luxray", "height" : 1.4 }
	{ "_id" : ObjectId("5643f5ac8a3351185ddd5461"), "name" : "Pikachu", "height" : 0.4 }
	{ "_id" : ObjectId("5643f6e88a3351185ddd5462"), "name" : "bulbassauro", "height" : 0.5 }
	```
	
## 2. Liste todos Pokemons com a altura maior ou igual que 1.5;
	
	
	```
	var query = {height: {$gte: 1.5}}
	db.pokemons.find(query,campos)
	{ "_id" : ObjectId("5647233fddd3df0aacc81f78"), "name" : "heatran", "height" : 1.7 }
	{ "_id" : ObjectId("5647233fddd3df0aacc81f7a"), "name" : "bouffalant", "height" : 1.6 }
	{ "_id" : ObjectId("5647233fddd3df0aacc81f7b"), "name" : "Mega mewtwo Y", "height" : 1.5 }
	{ "_id" : ObjectId("5647233fddd3df0aacc81f7c"), "name" : "Armaldo", "height" : 1.5 }
{'fraction_non_alphanumeric': 0.19990128331688056, 'fraction_numerical': 0.12438302073050346, 'mean_word_length': 4.553424657534246, 'pattern_counts': {'":': 0, '<': 6, '<?xml version=': 0, '>': 6, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4041719', 'n_tokens_mistral': 1087, 'n_tokens_neox': 939, 'n_words': 186}