Able to retrieve data from multiple tables using SQL

Question 1

How can you select only the different values?

Answer 1

SELECT DISTINCT(column_name) FROM your_table_name;

Question 2

How can you manipulate the order of the result?

Answer 2

To sort the rows in the result set, you add the ORDER BY clause to the SELECT statement.

The following illustrates the syntax of the ORDER BY clause:

SELECT
select_list
FROM
table_name
ORDER BY
column1 [ASC|DESC],
column2 [ASC|DESC],
…;

Question 3

foxshop inner join

Answer 3