ASCI Logo
ASCI.Academy
LearnPracticeCompeteCareer
Sign InGet Started

Search ASCI Academy

Universal search across Courses, Lessons, Skills, Projects, Challenges, Competitions, Jobs, Internships, and Users

cloud productivity

Curriculum Index

Current LevelInitiate
0/ 500 XP
Gravit Certificate:
100% Required
  • 1.1 The QUERY Function in Google Sheets
•
1
2
3
4
5
6
7
8
9
10
Module 1: Advanced Google Sheets & Dynamic Array Formulas•Lesson 1

1.1 The QUERY Function in Google Sheets

### Google Visualization API Query Language
Google Sheets allows you to run SQL-like strings on cell ranges:
=QUERY(A1:E100, "SELECT A, B WHERE C > 500 ORDER BY B DESC", 1)
Python 3.11
•
Interactive Challenge
+50 XP
Challenge Objective

Filter rows where value > 500 and print 'QUERY_RESULT: ['Engineering', 'Sales']'.

solution.py
UTF-84 SpacesAuto-saved
cpython3.11:~/workspace
CPython 3.11.8 (WASM)
$python3 -u solution.py
Click "Compile & Run" (or press Ctrl + Enter) to compile AST, verify bytecode, and execute the solution.