Python3IDE vs SQL Challenge

Python3IDE is an offline Python3.7 integrated development environment software with built-in common scientific libraries. It is a powerful helper for you to learn and practice Python. New: add offline C/C++/PHP/Lua integrated development environment. 【Built-in module】 -tkinter -turtle Scientific computing, data analysis and machine learning library -numpy-1.18.0 -pandas-0.25.3 -scipy-1.4.1 -scikit-learn-0.22.1 -statsmodels-0.11.1 -linearmodels-4.17 -sympy-1.5 -patsy-0.5.1 Visualization library -notebook-5.7.4 -matplotlib-3.1.2 -seaborn-0.10.0 -plotly.py-4.8.1 -bokeh-2.0.1 -pyecharts-1.7.1 UI library -kivy-2.0.0 -ipywidgets-7.4.2 Game library -SDL2 -SDL2_image -SDL2_gfx -SDL2_mixer -SDL2_ttf -pysdl2-0.9.8 -pygame-2.0.1 Image processing library -Pillow-7.0.0 -scikit_image-0.16.2 -imageio-2.8.0 -networkx-2.4 -opencv_python-4.2.0.32 Network library -pycurl-7.43.0.5 -httpie-2.0.0 -requests-2.22.0 -flask-1.1.1 -django-3.0.4 Other libraries -lxml-4.4.2 -simplejson-3.17.0 -tushare-1.2.48 【Features】 -Automatic association prompts, automatic indentation, and code highlighting. -Run scripts offline and locally, support input -Built-in common scientific computing library -Support Pip to install third-party libraries (line Python libraries) -Support Jupyter NoteBook -Built-in ipynb file previewer, so you can preview quickly without starting Jupyter Notebook service -Built-in file download management, support background download, you can download many python codes and learning libraries on the Internet at any time, such as github, etc. -Support file upload, share, download, etc. (via Jupyter Notebook service), support itunes to share documents -Built-in browser, you can open Jupyter Notebook page directly in this App, or open other web pages -Support multiple documents, you can open code editors, tutorial documents, interactive interpreters, browsers, etc. in multiple tabs, so that you can read the documents and learn while writing code -Support Python interactive interpreter, allowing you to enter code while executing -Built-in many Python learning tutorials, including python, numpy, matplotlib, pandas, scipy, sklearn, data analysis, machine learning, artificial intelligence, etc. "Auto Subscription Member Instructions" 1. Service name: consecutive year 2. If you purchase an account of an automatic subscription member, your iTunes account will be deducted 24 hours before the expiration of the monthly subscription period. After the deduction is successful, the subscription period will be extended. 3. If you need to cancel the subscription, please manually open the Apple phone "Settings" --> enter "iTunes Store and App Store" --> click "Apple ID", select "View Apple ID", enter the "Account Settings" page, click "Subscribe", select Himalaya VIP membership service to cancel the subscription. If you do not close the subscription at least 24 hours before the end of the subscription period, you will be deemed to agree to continue to authorize, and the subscription will be automatically renewed. "Automatic Subscription Service Agreement" https://www.jianshu.com/p/47341a0a9466 "User Agreement" https://www.jianshu.com/p/8ee503e0ae6f "User Privacy Agreement" https://www.jianshu.com/p/8ee503e0ae6f — Contact and feedback — If you have any questions or suggestions about the product, please contact us Email: python3ide@aliyun.com

Feed your brain. Query up. Learn SQL the way you will actually use it: one query at a time, against a real database, right on your phone. SQL Challenge is a single path of original questions. Each level hands you a small database and asks for one thing, and you answer with one SELECT. A real SQLite engine ships inside the app and runs your query on the spot — no server, no signal, no waiting. Then it runs your query again on rows you have never seen. Hard-code what was on the screen and you will hear about it. That is the whole difference between a query that looked right and a query that is right. Free to start: the opening levels are free, then unlock the full path with a single one-time purchase. No subscription, no ads, no account. WRITE REAL SQL • A keyboard built for queries: a clause row for SELECT, FROM, WHERE, JOIN, GROUP BY, ORDER BY and the aggregates, and a toggle that upper-cases keywords while leaving your table and column names exactly as typed • A schema panel above the editor: every table with its columns, their types, the row counts, and the first rows to look at • A result sheet that puts your table next to the expected one, so you can see which rows are extra, which are missing, and which column came back under the wrong name FIVE WORLDS TO QUERY • Five invented databases, none of them borrowed from a tutorial: an online shop, a school, a library system, an airline and a music service • Hidden variants of the same schema — an empty table, a tie at the top, a NULL where you assumed a number, a row with nothing to join to — decide whether you answered the question or just the screen LEARN THE RIGHT WAY • Three tiers of hints from Tuple, a cyan beaver who is smug about engineering and on your side anyway • A curated solution once you pass: the obvious query, the better one, and why the difference matters • One path, no shortcuts, easy to hard: filtering and sorting, then joins, grouping and aggregates, then subqueries and common table expressions STAY MOTIVATED • XP, player levels, daily streaks and badges • Six themes, dark and light PRIVATE BY DESIGN • Works fully offline; no account, no tracking — your progress stays on your device • No ads, ever