User feedback collection in No-Code - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all columns from the feedback table.

No-Code

SELECT [1] FROM feedback;

Drag options to blanks, or click blank then click option'

Aall

B*

Ceverything

Dcolumns

Attempts:

3 left

💡 Hint

Common Mistakes

Using words like 'all' or 'columns' instead of *

Leaving the SELECT statement incomplete

The asterisk (*) selects all columns from the table.

2fill in blank

medium

Complete the code to insert a new feedback entry with user_id and comment.

No-Code

INSERT INTO feedback (user_id, comment) VALUES ([1], 'Great app!');

Drag options to blanks, or click blank then click option'

A'user123'

B123

Cuser123

D"user123"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around string values

Using double quotes instead of single quotes

String values must be enclosed in single quotes in SQL.

3fill in blank

hard

Fix the error in the query to get feedback comments where rating is 5.

No-Code

SELECT comment FROM feedback WHERE rating [1] 5;

Drag options to blanks, or click blank then click option'

Aequals

B==

C=

D===

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' or '===' instead of '='

Using words like 'equals' instead of operators

In SQL, the equality operator is a single equals sign (=).

4fill in blank

hard

Fill both blanks to update the comment for a specific feedback id.

No-Code

UPDATE feedback SET comment = [1] WHERE id [2] 10;

Drag options to blanks, or click blank then click option'

A'Updated feedback'

B=

C>

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting the string value

Using wrong operators like '>' or '!=' in WHERE clause

The comment must be a string in quotes, and the WHERE clause uses '=' to match the id.

5fill in blank

hard

Fill all three blanks to create a table for user feedback with id, user_id, and comment.

No-Code

CREATE TABLE feedback (id [1] PRIMARY KEY, user_id [2] NOT NULL, comment [3]);

Drag options to blanks, or click blank then click option'

AINTEGER

BVARCHAR(50)

CTEXT

DBOOLEAN

Attempts:

3 left

💡 Hint

Common Mistakes

Using BOOLEAN for text fields

Not specifying data types correctly

id is an INTEGER primary key, user_id is a VARCHAR string, and comment is TEXT for longer feedback.