Sure, here are the SQL queries for your requirements:

1. To create a database named 'emp':
```sql
CREATE DATABASE emp;
```
2. To create a table named 'employee' with 4 columns (I'll assume the columns are id, name, position, and salary for this example):
```sql
USE emp;
CREATE TABLE employee (
id INT PRIMARY KEY,
name VARCHAR(100),
position VARCHAR(100),
salary DECIMAL(10,2)
);
```
3. To see the structure of the 'employee' table:
```sql
DESCRIBE employee;
```
Please replace the column names and types in the 'CREATE TABLE' query with the ones you need for your table.

Question

Sure, here are the SQL queries for your requirements:

1. To create a database named 'emp':
```sql
CREATE DATABASE emp;
```
2. To create a table named 'employee' with 4 columns (I'll assume the columns are id, name, position, and salary for this example):
```sql
USE emp;
CREATE TABLE employee (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    position VARCHAR(100),
    salary DECIMAL(10,2)
);
```
3. To see the structure of the 'employee' table:
```sql
DESCRIBE employee;
```
Please replace the column names and types in the 'CREATE TABLE' query with the ones you need for your table.

Knowee AI · Accepted Answer

Sure, here are the SQL queries for your requirements:

1. To create a database named 'emp':
```sql
CREATE DATABASE emp;
```
2. To create a table named 'employee' with 4 columns (I'll assume the columns are id, name, position, and salary for this example):
```sql
USE emp;
CREATE TABLE employee (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    position VARCHAR(100),
    salary DECIMAL(10,2)
);
```
3. To see the structure of the 'employee' table:
```sql
DESCRIBE employee;
```
Please replace the column names and types in the 'CREATE TABLE' query with the ones you need for your table.

write sql query for the following:1. create database - emp2.create table - employee with 4 columns3.To see table structure

Question

Write SQL query for the following:

Solution

Similar Questions

Upgrade your grade with Knowee