Task 74:

Search by pattern

From the staff table, select all employee data whose last name starts with the letter 'K'  using the keyword like.

Use SQLite syntax to write your answer. Descriptions of tables are provided in the right pane.

Write your request in the field below and click the "Check it!" button.

Get hint

Copy code Clear editor

Querynomicon Database: table structure and overview

Querynomicon (SQLite) is a compact training database for learning SQL fundamentals with clear and simple examples.

This page presents the tables, key columns, and sample rows for hands-on SQL practice.

The Querynomicon database contains 5 main tables.

department - table of departments.

ident	name	building
gen	Genetics	Chesson

little_penguins - table of little penguins.

species	island	bill_length_mm	bill_depth_mm	flipper_length_mm	body_mass_g	sex
Gentoo	Biscoe	52.1	17	230	5550	MALE

penguins - table of penguins.

species	island	bill_length_mm	bill_depth_mm	flipper_length_mm	body_mass_g	sex
Gentoo	Biscoe	52.1	17	230	5550	MALE

staff - table of employees.

ident	personal	family	dept	age
7	Abram	Chokshi	gen	23

machine - table of machines.