The end_date is the end of the period you wish to calculate as a fraction of a year. The [basis] lets us define the âyearâ in a few different ways. 1 will give us the actual year. The DATE function takes a numerical year, a numerical month between 1-12, and a day between 1-31.
A. There are general guidelines for each literary category: Short stories range anywhere from 1,500 to 30,000 words; Novellas run from 30,000 to 50,000; Novels range from 55,000 to 300,000 words, but I wouldnât recommend aiming for the high end, as books the length of War & Peace arenât exactly the easiest to sell.
The average nonfiction book, if such a thing exists, runs about 50,000 to 75,000 words, but this can vary depending upon category. Biographies, for example, can run 200,000 words. How-tos or self-help usually have 40-50,000 words. The average adult novel runs approximately 100,000 words while those in other categories run 80-120,000 words. Every category will have an average length, including childrenâs books, young adult, business books, etc. You can use comparable, successful books as models to determine the length you book âshouldâ be.