Answer to Question #318069 in Databases | SQL | Oracle | MS Access for Adi

Question

Write an SQL query that returns for each article, its ID, title and the number of authors.

Answer 1

USE yourDatabaseName;

SELECT ID, title,numberOfAuthors FROM articles;