All Stories
SQL Exercise 4:IF
Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table:
In sql, Jan 21, 2020
SQL Exercise 3: LIKE REGEX
Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.Input Format
In sql, Jan 20, 2020
Answers of Front-end Job Interview Coding Questions
Try to answer the front-end job interview coding questions. The original questions could be found in the link below.
In workshop, frontend, Jan 20, 2020
Setting up the Raspberry Pi Watchdog!
介紹如何啟用樹莓派的硬體看門狗功能，讓它在系統當機時可以自動重新開機。
In Raspberry, Jan 20, 2020
SQL Exercise 2
Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one small...
In sql, Jan 19, 2020
SQL Exercise 1
Query all columns for all American cities in CITY with populations larger than 100000. The CountryCode for America is USA.
In sql, Jan 18, 2020
TOP 50 SQL interview questions: JOIN
What is a join?JOIN是SQL的關鍵字之一，使用的情境是在多張Table之中Query資料。
In sql, Jan 17, 2020
Iterator in Python
DefinitionIterator is any type of python object that can be used in ‘for loop’.An iterator must implement the following methods: _iter_ next (_next_ in python3)
In python, Nov 15, 2019
Generator in Python
Definitiongenerator-functionA generator-function is defined like a normal function. But it uses the “yiled” keyword to generate a new value rather than “return”. If the body of a def ...
In python, Nov 15, 2019
Featured
-
Reading Plan
In Reading Plan, -
Intro: Github pages and jekyll
In Jekyll, tutorial, -
How to implement Jekyll tags on github pages
In tutorial, -
The first mass-produced book to deviate from a rectilinear format
In tutorial, -
We all wait for summer
In Jekyll, tutorial, -
Powerful things you can do with the Markdown editor
In Jekyll, tutorial, -
Never stopped worrying or loving the bomb
In Jekyll, -
Markdown Example
In Jekyll, tutorial,